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?
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?
i.e
1. Does fuzzy match select the match with the highest similarity index first?
2. or the first one which is above the threshold?
Because if it is the latter, then I need to do 2 steps (1 exact, 1 fuzzy, and then fill the blanks in exact using fuzzy)
If it does the former, then I can directly do the fuzzy match itself
Does fuzzy match select the match with the highest similarity index first?
If it did not, what would be the added value of computing a similarity index? :)
For your other records (those that don't match @100%), it all depends on what you expect - some examples:

Hope this helps and answers your question
3 people are following this question.