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
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
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!