Compare two file and create a out file having selected data from both files

[Jevish]

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 .

[tom_montpool]

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.

[bpatel · Accepted solution]

hi @Jevish ,

here is what i came up with.

Attached is my workflow. i hope this helps!