Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

mascarenhas_lucas
8 - Asteroid
Spoiler
challenge_54.PNG
daniel_ferreira
8 - Asteroid

Follow my solution file attached...

ponraj
13 - Pulsar
 
AndyBate
8 - Asteroid

Complete

StevenBetts
8 - Asteroid

This felt a bit messy to me but I got to the required solution so I guess that's the main thing!

mickael_gest
8 - Asteroid

My solution :)

Wouter
8 - Asteroid

My solution:

 

Spoiler
challenge 54.jpg
JonM
8 - Asteroid
Spoiler
Cheated slightly on this one, and relied on Googles API to help me with this one!
luciebrett
8 - Asteroid

I started this and found it hard to extract the city, after looking at the solution I used the pipe idea however have kept my first attempt in there for the other fields.

STate
7 - Meteor

I feel like I brute forced this one with calculations, there is probably a better way to do this to ensure that it catches and filters out the street address.