Forum Discussion

mkohler28's avatar
mkohler28
Frequent Visitor
8 years ago

Merge not Finding Matches

I am trying to merge values from one table to the next, the main table has unique values. When I do the merge I continue to get null values on some rows but not others, even though the data is there. Any suggestions?

 

Need Help

3 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    8 years ago

    Could be due to non-printable characters or blanks. Clean and trim your key columns before the merge  (Text.Trim and Text.Clean):

     

    • mkohler28's avatar
      mkohler28
      Frequent Visitor
      8 years ago

      Thanks. I've tried that already but still getting the same results. 

      • ImkeF's avatar
        ImkeF
        Community Champion
        8 years ago

        Strange, you did that on both columns (in both tables)?

         

        Then you need to analyze the difference:

         

        • Text.ToList will create a list from both strings
        • if lenghts are both the same, compare each x-th element to find the difference