Dataiku compare data between two columns

Chandrima

We have two datasets that I have uploaded from local and then I am joining the data based on a key and merged the columns. then when I am comparing two column values I used the function like:

if(colA=ColB, "Match", "No Match")

Even though some column values are exact same still it is showing as No Match.

How to fix the issue.

Turribeach

The most likely scenario is that the column values are NOT exactly the same. Most likely they may have some spaces or some other hard to see differences. Post some funny samples of your files if you can’t find the differences.