Hi Folks,
I am new to Alteryx and have been given a task to compare two file and track the deltas .
Both files have columns to compare however both files have different data columns . I need to know how can i get the desired out as highlighted in the attached excel sheet .
Please advice . Any link to tutorial videos will help .
Solved! Go to Solution.
Use the Join tool.
Join on the field(s) that are common between your 2 files.
The R output will contain records in File 1 that aren't in File 2
The J output will contains records that are common to both
The L output will contain records in File 2 that aren't in File 1
Then you can use the Union tool to merge R, J, and L together to make a single table.