Forum Discussion
Solved
Merge not Finding Matches Against Custom Column
Hi all, I've searched up and down and not found any pertient results for my issue. I've created a custom column that extracts three characters out of a text string. I'm think attempting to do...
If you convert to real numbers you will lose the leading zeros. I would keep it as text. Use trim, then clean, then transform to lowercase (even for the numbers) then try it again. I actually just ran into this issue and by cleaning the column first, it worked.
The query editor is case sensitive. Are you sure the text matches in case as well as characters?