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 ,

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.

 

Alicia_Anderson's avatar
Alicia_Anderson
Resolver I
6 years ago

Thank you so much.   I did finally get this to work.   Yay!