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.
re: leading zeros - exactly why I did it as text, however for the purposes of merging and diagrams it would be a bit inconsequential.
re: the transform and cleaning. I would have to perform that function on the custom column and the column being imported with the Location table, correct?