Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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
Highlighted
Meteoroid
 
Highlighted
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.

Highlighted

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
Highlighted
Asteroid
Spoiler
54.PNG
Spoiler
 
Spoiler
 
Highlighted
Alteryx Partner
Spoiler
SPOILER

Challenge 54.JPG

Highlighted
Asteroid
 
Highlighted
Asteroid
Spoiler
54.png
Highlighted
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