Forum Discussion
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
- Vijay_A_VermaMost Valuable Professional
Use this (All matches at 0.6)
- JuanBolasHelper II
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.