community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #54: Data Prep Address Parsing

Highlighted
Asteroid

Here's my solution! I know that I did not rename the "Address Text" to "City", but I wanted to use only one tool.

Spoiler
Capture.JPG
Meteoroid
 
Asteroid
Spoiler
2019-07-21 13_36_53-Greenshot.png
Asteroid

@Marcel_GavrilaUsing one formula tool with multiple formulas that is quite a feat.  Nice.

Interesting challenge. Reused the text input provided in the solution, but otherwise most of the steps done through the formula tool instead of regex.

 

Spoiler
SolutionClipping.PNG
Asteroid
Spoiler
54.PNG
Spoiler
 
Spoiler
 
Alteryx Partner
Spoiler
SPOILER

Challenge 54.JPG

Asteroid
 
Asteroid
Spoiler
54.png
Asteroid

Used Delimiter text to columns to isolate string after Street references

Used REGEX to extract state

Then used count and substring formulas using the above derived data to extract city names

 

Spoiler
RL_challenge_54_Solution.png