Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #54: Data Prep Address Parsing

RWvanLeeuwen
11 - Bolide

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

 

 

AnnaA
Alteryx Alumni (Retired)

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.

piotrzawistowski
8 - Asteroid
 
joshuaburkhow
ACE Emeritus
ACE Emeritus

Got to use some regex!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
klyuka
8 - Asteroid

More deep Parsing by Formulas

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

Solved. 

Greg_Murray
12 - Quasar

Solution attached

Shaun_Rheeder
8 - Asteroid

Fun challenge and it really boots the regex skills.

 

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

 

 

Rhodrick
6 - Meteoroid
 
Etienne
8 - Asteroid

Pretty challenging!!