Skip to main content

Hello,

I use several ChangeDetectors to verify if the content of my "source tables" differs from the content in my "tables to publish". I would like to update the "tables to publish" only in case, if some changes occured. I tried to gather all records from the "added" and "deleted" outputs of the ChangeDetectors to check if there is at least one record that changed. In case there is changed values/geometries, i want to run the WorkspaceRunner, but only once (to call another fme workbench doing the database update).

Is there a way to do this? Thanks for any ideas!

 

Philip

What about a sampler after your tester? Sampling rate 1, First n features.


Hi @philip,

A very efficient method is using the CRCCalculator:

https://knowledge.safe.com/articles/1124/creating-a-unique-identifier-crccalculator.html

This way you only need one workspace to detect the changes and apply it to the database.

Hope this helps.


Thank you very much!

Those two answers from you match perfectly for my Task!


Reply