Forum Discussion

hokiefan1113's avatar
hokiefan1113
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Find mismatches between columns

I've merged two Employee Data tables from different databases. I want to see if there are mismatches between corresponding columns (ex. are there any mismatched entries in employee FULLNAME fields). What's the best way to go about this?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi hokiefan1113

     

    Since you have merged two data sets, i assume you have all data in one table with names something like FULLNAME 1( from table1) ad FULLNAME2 ( Table 2, merged & resides in Table 1 now).

     

    IF( Table1[FULLNAME1] = Table1[FULLNAME2], "Matching","Not Matching"

     

    Thanks

    Raj

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi hokiefan1113

     

    Since you have merged two data sets, i assume you have all data in one table with names something like FULLNAME 1( from table1) ad FULLNAME2 ( Table 2, merged & resides in Table 1 now).

     

    IF( Table1[FULLNAME1] = Table1[FULLNAME2], "Matching","Not Matching"

     

    Thanks

    Raj