LinkBack URL
About LinkBacks
I want to create a merge between 2 tables, I want to use fuzzy match wherever exact match is not possible.
Do I have to do this in 2 different steps? or does the fuzzy match itself, check for an exact match before making it fuzzy?
I want to create a merge between 2 tables, I want to use fuzzy match wherever exact match is not possible.
Do I have to do this in 2 different steps? or does the fuzzy match itself, check for an exact match before making it fuzzy?
It uses a similarity threshold: https://support.microsoft.com/en-us/...4-bd3962b90649
If it's looking for similarity, then assuming you haven't given it too broad a brush with too low a setting, it will find exact matches fine. What's the purpose for it?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi, Thank you for your answer
My Use case is:
I want to do a normal match first. and use fuzzy match only in cases where I do not have an exact match.
So, can this be accomplished by doing the fuzzy match directly?
(Does fuzzy match select the match with the highest similarity index first? or the first one which is above the threshold?)
Or should I first do an exact match and then a fuzzy match and then merge these 2 results
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks