Forum Discussion
Power Query: Enable "Use fuzzy matching to perform the merge" Option
Hello, I am using Excel 2016 version with the Fuzzy Lookup Add in already installed. For some reasons, I can not see the option "Use fuzzy matching to perform the merge" under the Join Kind"'s Merge...
SalaLoocki Hi there,
I have the same problem, I discovered that I can amend the regular matching formula with the fuzzing formula.
You first matching the 2 tables and then add the word "Fuzzy" here (Formula Bar):
= Table.FuzzyNestedJoin(#"Changed Type", {"Last Name"}, Table4, {"Last Name"}, "Table4", JoinKind.LeftOuter)
I hope this helped you 🙂
Yes, and it could be better to add optional parameters as here https://docs.microsoft.com/en-us/powerquery-m/table-fuzzynestedjoin.
By the way, some other functions/connectors also work if code them directly, even if they are not in user interface of particular version of Excel (I don't mean functions which are never in user interface).
