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

Question

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 .

Logic and explanation .xlsx

bpatel · Accepted Answer

hi @Jevish ,

here is what i came up with.

Attached is my workflow. i hope this helps!