Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Icon for Resolver I rankResolver 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...
Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

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