I am trying to clean words in the field TITLE using a Fuzzy Match tool.
The Fuzzy Match tool is set to Purge. See settings below.
The actual data set has 1,500 records.
Below is a sample of the output.
Notice how
Ratcheting the Match Threshold from up or down seems to have very little impact.
Any suggestions?
Solved! Go to Solution.
Can you provide output including the Record ID?
Also, select the options for Output Match Score and Output Generated Keys. Some words can generate multiple keys.
Search for Fuzzy Match in the training videos, under Learn > Academy > Videos: https://community.alteryx.com/t5/Videos/bd-p/live-training
Chris
I found the Fuzzy Match Tool Mastery article. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485
It's not perfect, but it helps.