Forum Discussion
How to merge two tables based on a partial match
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.
I am having a hard time getting this to work. I get an error "Token Identifer expected". It seems to have a problem with the (1). See image.
Hello Alicia_Anderson
try to substitute this code
(l) => Text.Contains( [Release Table], l)with this one
(oneint) => Text.Contains( [Release Table], oneint)Hope this helps
Jimmy
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.
Thank you so much. I did finally get this to work. Yay!
