question

JacobJoseph-7393 avatar image
0 Votes"
JacobJoseph-7393 asked Lz-3068 answered

Fuzzy match in Powerquery, does it check for an exact match first?

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?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Lz-3068 avatar image
0 Votes"
Lz-3068 answered

Hi @JacobJoseph-7393

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:

92523-demo.png

Hope this helps and answers your question



demo.png (96.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Lz-3068 avatar image
0 Votes"
Lz-3068 answered JacobJoseph-7393 commented

Hi @JacobJoseph-7393

The [Similarity Index] should answer your question:

91711-demo.png
91859-democont.png



demo.png (149.7 KiB)
democont.png (73.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·