Forum Discussion

rpiboy's avatar
rpiboy
Frequent Visitor
9 years ago
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...
Need Help
  • kcantor's avatar
    kcantor
    9 years ago

    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's avatar
kcantor
Community Champion
9 years ago

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.

rpiboy's avatar
rpiboy
Frequent Visitor
9 years ago

kcantor

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?

  • kcantor's avatar
    kcantor
    Community Champion
    9 years ago

    rpiboy

    You are correct. Always duplicate the clean, trim, and transform on any columns you are trying to match. I went from matching 1 out of 8257 to all of them by cleaning up the columns.