?? Work at Pickup Points � Flexible schedule

Power Query Fuzzy Matching Makes Lookups EASY!

MyOnlineTrainingHub 66 views

Download

Download Video

Comments

fantastic
Comment from : @mohamedabdellatif86

how d you match the positive and negative amounts in excel power query
Comment from : @georgefandamu5115

WAY too fast
Comment from : @robotmanx2009

very good exponation!
Comment from : @SR71112

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?
Comment from : @datafreak911

Thank you for the video Can you tell me how you create a new table with from and to columns?
Comment from : @munkh-erdenechimiddorj9025

How do i use this fuzzy match to time into unevent group of timing Eg 801am, 2pm 245pm 258pm will group to 8am to 3pm shift, while 301pm 459pm 859pm can group into the 3pm to 9pm shift?
Comment from : @elijahchongtao

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 br brHowever, 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
Comment from : @earningthomas4640

I used to have to install an add in to do Fuzzy match lol
Comment from : @MyRockMyFortress

This is helpful, but can you explain how he got the data for the Transform table?
Comment from : @ToddJ326

Can I please request you to make some more videos on web scraping on power query? Like the one you made before in this playlist?
Comment from : @shrikantbadge3978

very helpful - thank you very much indeed!
Comment from : @MegaTrickykid

Awesome!!!!
Comment from : @mathewinmuscat

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
Comment from : @qasimjan5258

Greats!
Comment from : @osielgutierrez7837

Is this the same as the Microsoft Labs Fuzzy Lookup add-in?
Comment from : @markusher1621

Hi Munda, it's very useful technique
Comment from : @KuldeepSingh-nq1vi

Great video Thanks Can you tell me how to create a column that shows the Similarity score?
Comment from : @chocolate_guy

Thank you very much!
Comment from : @superyngo

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
Comment from : @admiralgeneralaladeen9437

I did not have fuzzy option in power query
Comment from : @bestrecitationofharamainim8951

You are too fast, and that makes you helpless
Comment from : @iteefmedia4485

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
Comment from : @mtstans

Woooww this is so a secret feature of PQ 😵brThanks a lot Mynda!
Comment from : @teoxengineer

Very informative but too fast towards the end I hope you could explain more step by step instead of keep going
Comment from : @soheehan9180

Thanks for this knowledge 😁😁😁
Comment from : @shortclipsvideos8573

This is GOLD! 🙌🏾
Comment from : @clickbisi7016

hi there is there a way to condense 14 different files into 1 file which have all different timers on them
Comment from : @tcrlrunner1128

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!!
Comment from : @wayneedmondson1065

I did merge query between 2 tablesbrEvery ID has many transaction ,, how can I return first & last date for every ID ?
Comment from : @SamehRSameh

Hi, have you worked with Qlik? Is there a big difference between Qlik and PowerBI?
Comment from : @parvelinho

NAMASTEbrhow can we use feature like pivot table in Power query so we don't have to repeat same work daily plz help brif u have made any video on that plz guide me to the videobrthanks very much
Comment from : @kg1980

This are the feature that only Mynda explains, it is so useful!brbrBy the way, the link to the file is not working!
Comment from : @felipe4181

Very useful tip Thanks to you both for sharing and being so didactic (an ability that I highly appreciate)
Comment from : @josecarlosconejo5724

From Egypt, thank you Mynda ,we love you 💓
Comment from : @ahmadeid2

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 bitbrPlus, his diction is less clear to understand than Mynda's for me (french)
Comment from : @anaismartin7384

I need to enrol the complete Excel CoursebrHow can go about?
Comment from : @jivasjacopo2637

Another great video Mynda, thank you!
Comment from : @chrism9037

Wow That is all
Comment from : @craigsmall7984

Great I liked Thanks Mynda!
Comment from : @Luciano_mp

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
Comment from : @usmanyousaf8549

Cool stuff Thanks for sharing Mynda & Phil
Comment from : @YouExcelTutorials

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
Comment from : @markbainbridge3240