Power Query Fuzzy Matching Makes Lookups EASY! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Admiral
Hi Mynda, Thanks for sharing valuable knowledge. I am looking for some help - my datasets are a bit big. One table has 3K rows and the other has 130K rows. I am trying to find fuzzy matches from the 3K table to the 130K table. I tried this with Fuzzy Lookup add-in in excel and also followed your video and tried it using power query... but both methods are taking forever... and even after 15 minutes I don't see any results. Can you please help me? The client's requirement is to do a Fuzzy match because we know there are definitely many mismatches with spelling and other typing mistakes though the products are the same.
reply
Hi Mynda, Thanks for sharing valuable knowledge. I am looking for some help - my datasets are a bit big. One table has 3K rows and the other has 130K rows. I am trying to find fuzzy matches from the 3K table to the 130K table. I tried this with Fuzzy Lookup add-in in excel and also followed your video and tried it using power query... but both methods are taking forever... and even after 15 minutes I don't see any results. Can you please help me? The client's requirement is to do a Fuzzy match because we know there are definitely many mismatches with spelling and other typing mistakes though the products are the same.
reply
Phil
I'm very keen to get this working, I've wanted fuzzy matching in Excel for years and I have briefly used Power Pivot in the past. Unfortunately, whenever I load a dialog window in Power Query Editor eg 1:36 Merge Query as New, the dialog box is not large enough and it crops the outer c.50 pixels all around. I cannot see or select some of the critical icons/widgets. I've Googled this problem and found no solutions, I've tried disconnecting the external monitor and can't get it to display correctly. Is this something you have come across before?
reply
I'm very keen to get this working, I've wanted fuzzy matching in Excel for years and I have briefly used Power Pivot in the past. Unfortunately, whenever I load a dialog window in Power Query Editor eg 1:36 Merge Query as New, the dialog box is not large enough and it crops the outer c.50 pixels all around. I cannot see or select some of the critical icons/widgets. I've Googled this problem and found no solutions, I've tried disconnecting the external monitor and can't get it to display correctly. Is this something you have come across before?
reply
Wayne
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!!
reply
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!!
reply
Matthew
HI, I have a table with 16 rows and 30 columns of data that equal either -1,0, or 1. I'm trying to match this with another table a larger range of the same data. What I'm trying to do is categorize my data from my new table to old table. Any videos or suggestions for this? I couldn't get it to work with the information presented in this video. Thanks.
reply
HI, I have a table with 16 rows and 30 columns of data that equal either -1,0, or 1. I'm trying to match this with another table a larger range of the same data. What I'm trying to do is categorize my data from my new table to old table. Any videos or suggestions for this? I couldn't get it to work with the information presented in this video. Thanks.
reply
itech
NAMASTE
how can we use feature like pivot table in Power query ....so we don't have to repeat same work daily plz help
if u have made any video on that ...plz guide me to the video...
thanks very much
reply
NAMASTE
how can we use feature like pivot table in Power query ....so we don't have to repeat same work daily plz help
if u have made any video on that ...plz guide me to the video...
thanks very much
reply
Ana-s
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).
reply
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).
reply
Usman
using power query how to extract data that contains email addresses as it gives error [Email Protected-. I posted the question on forum .. But no answer. appreciate if you can answer here . THanks
reply
using power query how to extract data that contains email addresses as it gives error [Email Protected-. I posted the question on forum .. But no answer. appreciate if you can answer here . THanks
reply
mark
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.
reply
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.
reply
Cherian
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?!?
reply
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?!?
reply
Add a review, comment
Other channel videos
