Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
lasersharks

Fuzzy Merge Doesn't Match Documentation

Submitted by Kudo Collector on ‎06-23-2022 01:14 PM

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

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎06-27-2022 02:12 AM
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
Kudo Collector
Kudo Collector
‎06-27-2022 02:21 AM

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.

Idea Statuses