Checking

[samxhander09]

Hi team, im trying to do a check where I'm comparing file 1(my input file) to file 2(my output file)and make sure there are no missing records in my output, again basing on my input file. I want it to either give an error message or output those that did not have a matching data.

[binuacs · Accepted solution]

@samxhander09 have you tried the macro 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Crew-Delta-Macro-to-compare-tw...

[samxhander09]

Hi @binuacs !

What I have so far is this,

I have both the input and output connected to a select tool and then joined by similar columns, now whatever data is not joined from my input will be outputted to alert the user. Would that work?

I checked the macro, as per the description "If the two datasets have the same columns and the same data for each row, it will run without errors", i wonder if it would affect the result if say, one of the data sets has different order of row values. 

[binuacs]

@samxhander09 The macro will fail if you have different data in the same field,  I think your approach should work to compare two files.

[samxhander09]

@binuacs , thanks really. I appreacite it!