Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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