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
Hi @SouravKayal
Join the data together on both fields and review the L/R anchors for dropouts (changes):
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
@tkozlyk You can transpose then join on the appropriate fields to find you differences
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 !
@tkozlyk Glad I could be of help and and that you were able to get your expected outputs