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?
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