Forum Discussion
SalaLoocki
Nov 06, 2019Copper Contributor
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...
SergeiBaklan
Dec 16, 2019Diamond Contributor
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).
Salahloocki
Jan 08, 2020Copper Contributor