Find mismatches between columns

[hokiefan1113]

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?

[Anonymous · Accepted solution]

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