Input = Output match

[Kinetic_analytics]

Hello:

At the end of the workflow, I would like to show many records come in that many records go out.  Are there any tools to show this kind of correctness in workflow?

For instance, I  have 10000 records as inputs in my base file output should be 10000 records. How can I show reconcile sheets at the end of my workflow to prove the correctness of the Workflow?

Thanks

[Luke_C · Accepted solution]

Hi @Kinetic_analytics 

I would do something like this:

1. Use record count tools on each dataset
2. Join together by record position
3. Filter to make sure they are the same
4. If they are not, use a message tool to throw an error or warning

[Kinetic_analytics]

Thank you.