We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Who is good at Fuzzy Matching? Please help me :(

rively90
8 - Asteroid

Hi,

Hi, I run fuzzy match tool and it's been running for 3+ hours and still keep going. What did I do wrong? what's the proper setting?

I'm trying to correct:

For example,

Correct: Los Angeles

Incorrect: Las Angelas

*Las Angelas is a typo. But, the tool will group them together to the correct one.


Second example:

Correct: Los Angeles@!#@!#

Incorrect: Los Angeles,CA

*I don't need to see ,CA there. Just the name of the city.

 

Third Example:

Correct: Edmonton

Incorrect: Edmonton Alberta

 *I don't need to see Alberta there. Just the name of the city.

 

Currently, the Route , Route Departure, Route Arrival, and Via are to be corrected.

 

There are a lot of typos in my data and just wondering the quickest way to handle this and almost impossible to me to correct one by one. Thank you!

 

0 REPLIES 0
Labels
Top Solution Authors