Forum Discussion

JuanBolas's avatar
JuanBolas
Helper II
3 years ago

Match based on data from another table


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

 

2 Replies