Match based on data from another table

[JuanBolas]

Hello

I'm a newbie in Power BI and I need a bit of help.

I need see if the values in a column (cargo) in table called Transaction Table match the Item keywords in a table called Categories table.

If there is a match with the Item keywords, the corresponding Category to that Item should be added to a new column in the Transaction table called.

If there are multiple matches, we just need to keep the first match.

Here are the tables.  This dummy data can be found here:  https://docs.google.com/spreadsheets/d/1HVohp0SgMZ9B39F2l36IJ0tGDLmoGB3cfc9-BNk-QiU/edit?usp=sharing

I tried a fuzzy merge query (left outer join) with varying thresholds. 0.6 gave me too bad matches and 0.7 skipped too many items

Thanks in advance

[JuanBolas]

Hello @Vijay_A_Verma,

I tried what you proposed but with real life data I'm getting a considerable number of false matches.  I tried changing the fuzzy match threshold but above 0.7 it gives me very few matches (even though the keywords are present). Any suggestions? 

Thanks in advance.

[Vijay_A_Verma]

Use this (All matches at 0.6)

https://1drv.ms/x/s!Akd5y6ruJhvhulvZW_xVC3NaVy3J?e=pKy5OS