Checking

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.

Data Investigation

Accepted answers

binu_acs

@samxhander09 have you tried the macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Crew-Delta-Macro-to-compare-two-excel-files-dynamically/td-p/1033070

All comments

binu_acs

@samxhander09 have you tried the macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Crew-Delta-Macro-to-compare-two-excel-files-dynamically/td-p/1033070

samxhander09

Hi @binu_acs !

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.

Control Check.PNG

binu_acs

@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

@binu_acs , thanks really. I appreacite it!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703