Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

NatSnook
アステロイド
スポイラ
Challenge 54.JPG

That was harder than i thought it would be.

hanykowska
ボリード

A bit tricky that one

robert-headington
アステロイド

This is not an optimal solution but is what I came up with

lordoforange
メテオール

Here is my solution

AnthonyG
アトム

PictureThis_20190312_161019.jpg

AmNotARobot
アステロイド

I had to peek at solution when I couldn't figure out how to handle 1 word versus 2 word City names. Once I did, well...D'oh

BenMoss
ACE Emeritus
ACE Emeritus

Here's where I got :D

 

スポイラ
2019-03-14_16-31-12.png

 

AdamBiggs
メテオール

Took me a while but got it. 

PeterF
アステロイド

:-)

JackParry
アステロイド

Solution