How to get mismatch dataset in my sample data

Question

Just wanted to ask again in a different scenario on how to identify the mismatch under Name column ( ie. case sensitive, double spacing, additional character)  only using joint tool  (if not, other tool/s that can identify the mismatch of the data) using my latest dataset?

Ruby.xlsx

Diamond.xlsx

Output.xlsx

DataNath · Accepted Answer

@abardaje something like this? I just conduct the join on record position and then you can use a Filter with the expression that one name Contains the other. The reason I use contains is because you can specify case sensitivity.

True anchor - identical matches:

False - Any differences (see record 6 showing case sensitive matching):