Hi There, In my fme workspace, I am reading from a SQL Server database. After few changes, I am writing to a SQL Server spatial database. I want to implement a check to see if the same number of records are written as the source and not sure of the best way to accomplish that. This is to check if there were any records missed during to any error. If that's the case, then I want to skip writing to the database. Thanks Jay
Page 1 / 1
Just to add that I tried using statistics Calculator and I can do the test (in Count & out count) but I am missing the decision part if my condition matches then proceed with the update. Here is a snapshot of my current workspace.
recordcountcheck.pngrecordcountcheck.png
If you have done the test, the easiest way is to send the passed output port to a featuremerger, merge on 1 and then send the merged output to the writer. If nothing comes out the passed port then nothing comes out the merged port
If you have done the test, the easiest way is to send the passed output port to a featuremerger, merge on 1 and then send the merged output to the writer. If nothing comes out the passed port then nothing comes out the merged port