Hi,
I have 2 questions
1. I'm wondering if there is any tool in Alteryx that detect the common name for the city. Maybe using AI, fuzzy matching, geocoding APIs or something? I don't know.
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.
2.
Context: I have 2 files: The Airlines Route Semi Clean will be the main file, which include: Route, Route Departure, Route Arrival, and Via.
There are a lot of fields that using 3 digits of airport code. For example: LAX, SFO, DEN, etc...
I have another file called "Airport Information" that contains 3 digits airport code and city located.
and I was just wondering if there is any way that we can replace those 3 digit codes with the city.
For example: LAX is replaced to Los Angeles
I'm assuming we need to do the JOIN, BUT the issue is that join will remove the city name that is already there in those 4 fields.
My current idea is: First, we need to make sure that Alteryx recognizes the 3 digits code, which will be the primary key for the joining. In my another file also has the 3 digits airport code. Then, those 3 digits code in the primary file will be replaced to the city from the secondary file. Is it possible?
I attached the excel files here. Could you please send the workflow here please? Thank you!
