Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Resolver I
6 years ago
Solved

How to merge two tables based on a partial match

I have two tables each with one column:  Release Table [Release] & Release CID Table [Release CID]. I want to associate Release CID to Release based on whether there is a exact match first and if no...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Alicia_Anderson ,

    my code included the small letter L "l" and not 1. 

    The reason for your error message is that you used a number instead. 

    So either replacing it with any character or a string like Jimmy801  mentioned should solve the problem.

     

    BTW: It might be more suitable for your use case to use the "Text.StartWith"- function instead of the "Text.Contains"-function.

     

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Alicia_Anderson 

why shouldn't row 8 not match with ABCD 11 ?

 

  • Alicia_Anderson's avatar
    Alicia_Anderson
    Resolver I
    6 years ago

    Yes, it matches but I want it to only match to one value and I want it to be the one with the most characters matched.   

     

     

    • ImkeF's avatar
      ImkeF
      Community Champion
      6 years ago

      Having problems to understand that logic: How about those other duplicates then?

       

       

      • Alicia_Anderson's avatar
        Alicia_Anderson
        Resolver I
        6 years ago

        ABCD 11.1.5 does not exist in CID Release table.

        ABCD 11.1 does not exist in CID Release table.

        ABCD 11 DOES exist in CID Release table. (MATCH)

         

        ABCD 11.2 does not exist in CID Release table.

        ABCD 11 DOES exist in CID Release table. (MATCH)

         

        ABCD 11.4.0 does not exist in CID Release table.

        ABCD 11.4 does not exist in CID Release table.

        ABCD 11 DOES exist in CID Release table. (MATCH)