Forum Discussion

hokiefan1113's avatar
hokiefan1113
Advocate 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). ...
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

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