Comparing data from 2 different reports to see if they match

[CherieACI]

I have 2 excel reports (inputs) that I'm trying to compare to see if the data matches each other. What is the best way to accomplish this? And is there a way for Alteryx to show which records don't match? 

Thank you!

Cherie

[messi007]

@CherieACI,

You can use the crew test "Expect equal" from the crew macro :

Here is the link for the crew macro : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740 

Hope this helps,

Regards

[CherieACI]

I was able to go a different route to get the results I needed. Thank you for the suggestion, I did download the crew macro and look forward to learning more about it!