community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Alteryx Certified Partner

I wonder about the robustness of my solution and ponder at discussing the way this data field was created in the first place... Using a Google API would be an absolutely brilliant move (as was demonstrated)

 

Spoiler
54.png

 

 

Alteryx
Alteryx

This was my first attempt at a Weekly Challenge because a cruel SE told me it would be easy :) @JamesMA 

 

It was a team effort but we got there in the end.

 
Alteryx Partner

Got to use some regex!

Asteroid

More deep Parsing by Formulas

Spoiler
Used Input Text Tool to create own data of street types.
Asteroid

Solved. 

Solution attached

Asteroid

Fun challenge and it really boots the regex skills.

 

Only used one formula tool so that's also a bonus.

 

 

Highlighted
Meteoroid
 
Asteroid

Pretty challenging!!