Skip to main content
Question

ChangeDetectors/ run WorkspaceRunner once (if change was detected)

  • May 5, 2017
  • 3 replies
  • 54 views

philip
Contributor
Forum|alt.badge.img+3

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

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.

3 replies

jdh
Contributor
Forum|alt.badge.img+40
  • Contributor
  • May 5, 2017

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


itay
Supporter
Forum|alt.badge.img+19
  • Supporter
  • May 5, 2017

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.


philip
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • May 8, 2017

Thank you very much!

Those two answers from you match perfectly for my Task!