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
  • 6 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

4 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • 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

nathanatsafe
Safer
Forum|alt.badge.img+7

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
  • September 28, 2017
nathanatsafe wrote:

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
  • September 28, 2017
danilo_fme wrote:

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..

 

Reply


Helpful Members This Week

Community Stats

31,488
Posts
119,372
Replies
39,108
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.