cancel
Showing results for 
Search instead for 
Did you mean: 
0

Fuzzy Merge Doesn't Match Documentation

The fuzzy merge documentation doesn't match observed functionality. The following page (https://support.microsoft.com/en-us/office/create-a-fuzzy-match-power-query-ffdd5082-c0c8-4c8e-a794-...) states:

 

Similarity Threshold     Indicates how similar two values need to be in order to match. The minimum value of 0.00 causes all values to match each other. The maximum value of 1.00 only allows exact matches. The default value is 0.80.

 

Can you explain the highlighted text in red as this doesn't actually work. Is it a bug in Power Query or a documenation mistake?

 

Status: Delivered

Hi @lasersharks 

These two figures are the results obtained when the Similarity Threshold is equal to 1 and equal to 0. You can see that when the Similarity Threshold is equal to 1, which is an exact match, the result is 1 to 1 (case doesn't count). When it is equal to 0, it is a fuzzy match, which can be one-to-many. This is the difference.

Ailsamsft_0-1656320934137.pngAilsamsft_1-1656320947706.png

Best Regards,
Community Support Team _ Ailsa Tao

Comments
Ailsa-msft
Community Support
Status changed to: Delivered

Hi @lasersharks 

These two figures are the results obtained when the Similarity Threshold is equal to 1 and equal to 0. You can see that when the Similarity Threshold is equal to 1, which is an exact match, the result is 1 to 1 (case doesn't count). When it is equal to 0, it is a fuzzy match, which can be one-to-many. This is the difference.

Ailsamsft_0-1656320934137.pngAilsamsft_1-1656320947706.png

Best Regards,
Community Support Team _ Ailsa Tao

lasersharks
Advocate IV

Are you saying that threshold controls the number of matches (one-to-many in your words). This is not what the docs say at all. The number of matches is controlled by the " Maximum number of matches  " setting. Please can you provide further clarity or ask someone in the PQ team to take a look.