Forum Discussion
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...
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.
The Query Editor's Merge query function has fuzzy matching capabilities.
I did try that with a couple variations. Everytime it returned only errors for each item.