Forum Discussion
Helper VCreating relationship between tables with imperfect column matches "fuzzy matching"?
I have 2 columns. in 2 separate tables. One has a precise name of a course whilst the other contains a more generic title for it, which is quite similar but not identical (and not similar in precisely the same way). I would like to create a relationship between the two tables based on those values ie some kind of "fuzzy" match. Is that feasible?
Hi Walt1010 ,
I'm afraid that directly using fuzzy matching rules to relate two tables in Power BI is not feasible. I recommend cleaning the data to ensure the values in both columns are consistent, so they can be related through exact matching.
Best Regards,
Bof
3 Replies
Hi Walt1010 ,
I'm afraid that directly using fuzzy matching rules to relate two tables in Power BI is not feasible. I recommend cleaning the data to ensure the values in both columns are consistent, so they can be related through exact matching.
Best Regards,
Bof- Ashish_Mathur
Super User
Hi,
Share some data to work with and show the expected result.
Walt1010a ha thanks. The answer I was expecting, but not hoping for 🙂
