Compare data from two tabs and output the discrepancies

Question

Hi,

I am VERY new to Alteryx and need help with a ,  hope, straight forward workflow.

I have a workbook with 2 tabs that have the same column names, and order, but the data is from two different sources. I am looking to compare the data and for the output the discrepancy. If there is a variance I am looking for the output to tell me what was the value in tab1 and tab 2 so I can confirm which is correct.  Please note column A in both tabs contain an ID that can be used for reference.

CathyS_Slalom · Answer

Hi @anncotter, you can read in both tab and then join them on the id. After that, you can add either formula to check the difference or a filter tool to filter on the discrepancy records, e.g. [NAME] != [Right_NAME].

JarekSkudrzyk · Answer

@anncotter hi,

you would need to cross tab data and compare the values using a single formula - you can take a look at my solution to this thread:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formula-tool-with-multiple-expressions-validating-multiple/td-p/921037
If this does not help - please share a sample data and I will gladly prepare a workflow:)