Power Query Fuzzy Matching Makes Lookups EASY!

Fuzzy Matching in Power Query now means we can match text with typos, upper and lower case and much more.

0:26 Example Data
1:28 Merge Tables
2:04 Similarity Threshold
3:29 Transformation Table

[khersheonteoh]

Nice one covering the fuzzy match. I didn't know there is a transformation table option! Thanks!

[markbainbridge]

Fuzzy logic plus Fuzzy Matching is perfectly compatible with my Fuzzy brain. More seriously as ever a very well and clearly explained tip. I definitely want to become a power query super user.

[cherianiype]

That is just awesome! Super fantastic! Incredible stuff! Very many thanks Mynda and Phil and team! Very much appreciate this. Where is the LOVE ICON?!?

[anaismartin]

Really interesting, but Phil is a little bit fast when he shows things. It would be cool if he slowed down just a tiny little bit.
Plus, his diction is less clear to understand than Mynda's for me (french).

[earningthomas]

This idea of fuzzy merge seems very promising. It reminds me of the xlookup function in a way. I think they are both similar in the sense of being able to shift parameters from 100% to less than 100% matches.

However, i think the power query example is a bit more reliable because you could litterally dial in the confidence level you want to achieve. I like that aspect to it. I'm sure i could find a million ways to use this.

[wayneedmondson]

Hi Mynda and Phil. Thanks for demonstrating fuzzy matching in Power Query. Although it is an enticing feature, I find it difficult to trust it except under the most simple circumstances. Even though it is more work, I prefer a transformation table to be the primary method against any data that really matters. That said, your demo of combining fuzzy match and a transformation table is a good use case, making the transformation table shorter for only those items that PQ can't resolve. Excellent! Thanks for sharing :)) Thumbs up!!

[teoxengineer]

Woooww this is so a secret feature of PQ. 😵
Thanks a lot Mynda!

[josecarlosconejo]

Very useful tip. Thanks to you both for sharing and being so didactic (an ability that I highly appreciate)

[ahmadeid]

From Egypt, thank you Mynda, we love you 💓

[larato]

Thank you Mynda and Phil. That will be really useful.

[ToddJ]

This is helpful, but can you explain how he got the data for the Transform table?

[KuldeepSingh-nqvi]

Hi Munda, it's very useful technique.

[munkh-erdenechimiddorj]

Thank you for the video. Can you tell me how you create a new table with from and to columns?

[darrylmorgan]

Hi Mynda/Phil Great Tips For Using Fuzzy Match...Thank You :)

[shoaibrehman]

Actually i was doing today learned more now about transform table.

[YouExcelTutorials]

Cool stuff. Thanks for sharing Mynda & Phil.

[chrism]

Another great video Mynda, thank you!

[MegaTrickykid]

very helpful - thank you very much indeed!

[qasimjan]

Hi Mynda andPhil thanks for the tip. I wanna know if I have many instances of Microsoft like Mcrft, Micrsft, mcrosft etc. Will the transformation table will be able to pick it up.

[datafreak]

Nice video. I would like to know how u got that transform table? is it something you already prepared or it was an automatic result?