Help please

[domantasmaurakas]

Hi, so I'm creating workflow. Basically what I want is to run SQL code, get the results, then run it after 4 hours and compare results to the 1st one and bring back only the new ones. For example I just run a code, it brings me 1800 records, i run it again, and it total lets say there is 1900, so 100 new records would be in the output. What tools would you use? It has to be something easy I just can't work it out, I know that somehow i have to run prior records before to compare it

[binuacs]

@domantasmaurakas use the join tool to compare the prior report and current report, in your workflow get the prior file using the input tool then compare the new records using the join tool, once all done append the new records to the prior record file