How to add more nicknames into fuzzy match tool?

knozawa

Hello,

I use a fuzzy match tool and would like to add more nicknames into the tool. Does anyone know how to do that?

Sincerely,

Kazumi

Tips and Tricks

Fuzzy Match

Accepted answers

MarqueeCrew

http://downloads.alteryx.com/Alteryx/Help/FuzzyFAQ.htm

Yes. Under the match function section of the Fuzzy Matching tool there is an option that utilizes a common Nickname table to check against and further identify duplicates. This selection can be used on a field that contains only the first name or a field that contains both first and last name. Adding to the Nickname table can be done by updating the database (Common Nicknames.yxdb ) located here: \ProgramFiles\Alteryx\RuntimeData\FuzzyMatch\Nicknames\

The Fuzzy Matching tool can also recognize independent Nickname tables by putting a copy of the table in the Nicknames folder. Tables in this directory will become available from the drop down box in the Nicknames section of the Fuzzy Matching tool.

All comments

MarqueeCrew

knozawa

Thank you @MarqueeCrew!

JudyN

The path has been updated to the following:

C:\Program Files\Alteryx\bin\RuntimeData\FuzzyMatch\Nicknames

skharel

I was able to add my own nickname table, 'AART Nicknames' into the 'Nicknames' folder but it is not showing as an option the drop down box when I try to edit match options for 'nicknames/abbreviation table (word match only)'. Do you know why this would be?

1.png

2.png

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703