Compare Two excel files for differences

[SouravKayal]

Hi Team, 

I have two files with data of a ID and Name and need to compare both to see any differences week over week

Table 1

ID                Name

513450         XYZ

513450         ABC

11111           6789AF

513130         XYZ

Table 2

ID                Name

513450         XYZ

513450         DEF

11111           6789AF

11111           ABC

513130         XYZ

513130         ABC

513450         ABC

the output should be

513450         DEF

11111           ABC

513130         ABC

i was trying with a record id and transpose , but dint work through. Greatly appreciate the help

[Luke_C]

Hi @SouravKayal 

Join the data together on both fields and review the L/R anchors for dropouts (changes):

[tkozlyk]

ok - but I am looking to compare every cell of 2 excel files with the same layout (field names & positions)

then must use transpose?

TDK

[Deano478]

@tkozlyk  You can transpose then join on the appropriate fields to find you differences  

[Deano478]

Hers is one way of doing it 

[tkozlyk]

Yes, thank-you !

I mocked up mine based on yours and it works well. In my CPI's with my current alteryx flows, I want to ensure the original o/p is not broken. Hence, I want to compare both excel files (previous to my CPI & after my CPI) - both excel files have same schemas - to ensure cell values are not changed.

Many thanks again !

[Deano478]

@tkozlyk Glad I could be of help and and that you were able to get your expected outputs