Fuzzy match with similarity column

[drop05]

Hello, i created a power query fuzzy match merge. And I am wondering either with VBA or power query if there is a way to add a column to give a number to represent the similarity of the two columns I am doing a fuzzy match. With 1 being exact and 0 being either its empty or doesnt match at all and anything lower than 1 like .8 means it is some what similar

 

[KRice]

Have you investigated using the SimilarityColumnName option?

 

[drop05]

Have you investigated using the SimilarityColumnName option?

I have not is there something/somewhere I can heck this out at

 

[KRice]

About halfway down this page, you'll see how you can invoke the "show score" option:

How fuzzy matching works in Power Query - Power Query

How-to article on the fuzzy matching feature in Power Query and how to better take advantage of it.

learn.microsoft.com

I'm not sure which function you're using that involves the fuzzy matching, but here is another link that describes the SimilarityColumnName option:

Table.FuzzyNestedJoin - PowerQuery M

Learn more about: Table.FuzzyNestedJoin

learn.microsoft.com

 

[Alex Blakenburg]

I used to direct people to using the Fuzzy Match Add-in because Power Query did not show the threshold while the Add-In did.
You can get the Add-In from Microsoft here:
Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

@KRice's post is very helpful and looking further in to it, it looks the Power Query graphical interface still does not support Fuzzy Grouping. I gather it is only available in the Online Version.
You can however now get to it by modifying the M Code.
In the below the line was created using the interface and I added the part in < , SimilarityColumnName="Similarity" >inside the square brackets.
(where the final "Similarity" was my new column name.)

    #"Merged Queries" = Table.FuzzyNestedJoin(Source, {"Name"}, qryTableMaster, {"Name"}, "qryTableMaster", JoinKind.LeftOuter,
                        [IgnoreCase=true, IgnoreSpace=true, Threshold=0.3, SimilarityColumnName="Similarity"]),

This video shows what it looks like in the Online version with the graphical interface updated.