compare 2 excel sheets and get mismatched fields

[dexter90]

Hi,

I am trying to build a workflow to compare 2 excelsheets with same columns and list out changes.I am inputting 2 excel sheets as below

excel 1

ID Name

1  abc

2 def

excel 2

ID Name

1  bac

2 def

Expected output in should show mismatched vales in below format:

ID Field_name    Excel 1_Value  Excel2_value

1      Name          abc                    bac

Any suggestion would be helpful.

[ztriano]

How about using the join multiple tool using the ID column as the primary key to match the datsets?