Compare two excel files - show values not matching

Susan DeWitt
Susan DeWitt Altair Community Member
edited July 2023 in Community Q&A

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?

Tagged:

Answers

  • Baba_Majekodunmi_703
    Baba_Majekodunmi_703
    Altair Employee
    edited July 2023

    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
    Susan DeWitt Altair Community Member
    edited July 2023

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

Categories