Comparing Data

[calvincarr29]

What's the most efficient way to compare two excel files and point out the differences?

[caltang · Accepted solution]

You can consider this:

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Is-there-an-Alteryx-tool-that-...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Compare-two-files-with-same-co... 

Or this: 

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Compare-two-data-sets-amp-high...

There's an Alteryx macro as well... but can't seem to find it. I'll paste it here once I do find it.

[Deano478 · Accepted solution]

@calvincarr29 I suggest you transpose both data sets then join them together and by doing so you will see all the similarities and differences from the join tool and when your happy you can cross tab the data back out again