Compare two excel files - show values not matching

Susan DeWitt

I have two excel files with the same fields and layout.  I want to compare them and show the records when specific values are not matching between the two files.  Would I do this with a negative join and use the values I want to compare as key fields?  If not, how would I do this in DPS?

Baba_Majekodunmi_703

Hi Susan,

I have to think about this and I believe a Lookup Join is your answer, not a negative join. I created a 5mins video take a look and let me know if it helps;

How to compare two excel files

 

Susan DeWitt

This was very helpful.  Thank you for taking the time to create the video!