Fuzzy matching in Power Query in Excel & PowerBI

preview_player
Показать описание
Matching between two tables is key in Excel, but we run into complications: John isn't Jon, My Jones isnt Dan Jones, and UK isn't the same as Great Britain, Power Query's fuzzy matching can still make these match!
Рекомендации по теме
Комментарии
Автор

At 1:50, you show the power query editor, which shows 14 queries total with three subfolders (loading, fuzzy lookup, and other). My editor doesn’t show any subfolders. I’m using Office Plus 2019. How do I find the option to load fuzzy to and fuzzy from?

dm
Автор

I have excel 2016, where in i donot see fuzzy match options, is there anyway i can do the same....kindly reply...

sunnybaggu