How to get mismatch dataset in my sample data

[abardaje]

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?

[DataNath · Accepted solution]

@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):

[abardaje]

Thank you! :)