Skip to main content
Question

How to match table names from 2 processes and then if a match write to output using tester?

  • September 28, 2017
  • 4 replies
  • 23 views
G

Dear all,

newbie question regarding the below.

Context: I am downloading a GDB from a drobBox each night. If the schema has not changed I wish to load the tables into SDE, along the way add a field with the download date (timestamper).

Specific question : My idea is to use the Tester to check if the "Unchanged" fme_feature_type_name from the ChangeDetector matches the fme_feature_type_name value from the TimeStamper , if so write to SDE. But it is not working as i imagine it.

Any suggestions for how I can solve this would be most appreciated

thanks in advance

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • September 28, 2017

Hi @gaborv73,

Instead to use the Tester transformer, i suggest you to use the transformer FeatureMerger.

And the output outside Merged is your result that you want.

Thanks,

Danilo

Partner Solutial Brazil - www.solutial.com.br
nathanatsafe
Safer
Forum|alt.badge.img+9
  • nathanatsafeSafer
  • Safer
  • 284 replies
  • September 28, 2017

Hi @gaborv73, thanks for posting your question!

If your fundamental question concerns comparing the two schemas, I'd check out this Q&A; post where @takashi demonstrates how to compare two schemas. As you've done, you can also use the Schema output port of your FeatureReader instead of a Schema reader. Might be worth a try!

Hope this helps.

Nathan

G
  • gaborv73
  • Author
  • 2 replies
  • September 28, 2017

Hi @gaborv73, thanks for posting your question!

If your fundamental question concerns comparing the two schemas, I'd check out this Q&A; post where @takashi demonstrates how to compare two schemas. As you've done, you can also use the Schema output port of your FeatureReader instead of a Schema reader. Might be worth a try!

Hope this helps.

Nathan

Thanks Nathan, it is that Q&A; post that got me started. What i don't understand is how to action those feature classes that pass as "unchanged" through the change detector. And by action i mean grab from the source gdb and write to the sde.

 

 

G
  • gaborv73
  • Author
  • 2 replies
  • September 28, 2017

Hi @gaborv73,

Instead to use the Tester transformer, i suggest you to use the transformer FeatureMerger.

And the output outside Merged is your result that you want.

Thanks,

Danilo

Thanks Danilo, Do I need to expose fme_feature_type_name for it to be available in the Requestor? (or do i just type it in). Is the GDB the requestor and the Schema the supplier? Currently all results from the supplier are going out the unmatched and the schema is going out the unreferenced..

 

Community Stats

32,093
Posts
121,876
Replies
39,733
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.