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.
kcantor
Community Champion
Community ChampionIf 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.
Thanks!
Clean/Trim/Lowercase helped. I didn't pick through each to determine which one did the trick on which column.