Forum Discussion
Merge Queries by text contain
Hello everyone, I refer to this query https://community.powerbi.com/t5/Power-Query/Merge-by-Text-Contain-Any-Multiple-values-in-a-row/td-p/745087 as I have a similar issue. (Also Nolock , since you p...
Thank you very much everyone for your input!
I found a simple solution here https://powerpivotpro.com/2019/02/powerquerymagic-conditional-joins-using-table-selectrows/ and it worked for me perfectly.
Cheers!
Ooh I see. Is there any particular example that I can refer to?
Here's my proudest work so far:
#"Added Custom" = Table.AddColumn(Index, "Match",
(k) => Table.SelectRows(#"Assignments",
each ([LocID]="*" or k[LocID]=[LocID])
and ([PSA]="*" or k[PSA]=[PSA])
and ([ST ID]="*" or k[ST ID]=[ST ID])
)
),
This does a semi-fuzzy match across three fields of the two tables.