Комментарии:
How do i use this fuzzy match to time into unevent group of timing. E.g. 8.01am, 2pm 2.45pm 2.58pm will group to 8am to 3pm shift, while 3.01pm 4.59pm 8.59pm can group into the 3pm to 9pm shift?
Ответить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.
I used to have to install an add in to do Fuzzy match. lol
ОтветитьThis is helpful, but can you explain how he got the data for the Transform table?
Ответить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?
Ответитьvery helpful - thank you very much indeed!
ОтветитьAwesome!!!!
Ответить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.
ОтветитьGreats!
ОтветитьIs this the same as the Microsoft Labs Fuzzy Lookup add-in?
ОтветитьHi Munda, it's very useful technique.
ОтветитьGreat video. Thanks. Can you tell me how to create a column that shows the Similarity score?
ОтветитьThank you very much!
Ответить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.
ОтветитьI did not have fuzzy option in power query
ОтветитьYou are too fast, and that makes you helpless
Ответить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.
ОтветитьWoooww this is so a secret feature of PQ. 😵
Thanks a lot Mynda!
Very informative but too fast towards the end. I hope you could explain more step by step instead of keep going.
ОтветитьThanks for this knowledge 😁😁😁
ОтветитьThis is GOLD! 🙌🏾
Ответитьhi there . is there a way to condense 14 different files into 1 file which have all different timers on them
Ответить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!!
ОтветитьI did merge query between 2 tables
Every ID has many transaction ,, how can I return first & last date for every ID ?
Hi, have you worked with Qlik? Is there a big difference between Qlik and PowerBI?
Ответить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
This are the feature that only Mynda explains, it is so useful!
By the way, the link to the file is not working!
Very useful tip. Thanks to you both for sharing and being so didactic (an ability that I highly appreciate)
ОтветитьFrom Egypt, thank you Mynda ,we love you 💓
Ответить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).
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?!?
ОтветитьI need to enrol the complete Excel Course.
How can go about?
Another great video Mynda, thank you!
ОтветитьWow. That is all.
ОтветитьGreat. I liked. Thanks Mynda!
Ответить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
ОтветитьCool stuff. Thanks for sharing Mynda & Phil.
Ответить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.
ОтветитьThank you Mynda and Phil. That will be really useful.
ОтветитьHi Mynda/Phil Great Tips For Using Fuzzy Match...Thank You :)
ОтветитьNice one covering the fuzzy match. I didn't know there is a transformation table option! Thanks!
ОтветитьActually i was doing today learned more now about transform table.
Ответить