Question

dynamic changedetector - to loop or not to loop?

  • 26 February 2019
  • 2 replies
  • 3 views

Badge +10

Hi started to use the new changedetector to identify changes between data stored in a database in sqlserver spatials versus a postgres SDE. I initially started doing it for each table but there are aroun 60 so quickly lost the will to continue.

I worked up the following dynamic tool:

At the moment it only works one feature at a time (currently I am just loading the table name in the first attribute creator.

My question is how should I run this for more that one table at a time. Will it work by passing a list of features to the feature readers or should I basically add this into a loop and just run one at a time through the loop.

I really welcome your recommendations.

Thank you

Oliver


2 replies

Userlevel 1
Badge +21
Set your attributecreator so that feature is set from a parameter, then set up a second workspace with a workspace runner to run the change workspace once for each table.
Badge +10
Set your attributecreator so that feature is set from a parameter, then set up a second workspace with a workspace runner to run the change workspace once for each table.

perfect, with give that a go.

Reply