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

Hammad_Rashid
11 - Bolide

image.png

lyon_abido
8 - Asteroid

Had a bit of trouble with using Regex, so I decided to brute force it instead, haha. 

Spoiler
Screenshot (160).png
PrachiD
8 - Asteroid

REGEX, PARSE, CORE TOOLS

Tofel
8 - Asteroid

Not as bulletproof as I hoped, but it should work for this.

 

Spoiler
Tofel_1-1681749183906.png

 

 

 

Spurs
8 - Asteroid
Spoiler
Spurs_0-1682092425762.png

 

scooby_snacks
8 - Asteroid

My solution. 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1682600006971.png

 

A fun challenge, thank you, @GeneR!  Thank you, @philip_ball and @NicoleJohnson  for trailblazing the idea of a  text input for street references.  I was able to leverage that in my solution.

Archie_bos
8 - Asteroid

Here is my solution

chandler-gjino
Alteryx
Alteryx

attaching my solution

NMangera
10 - Fireball
Spoiler
NMangera_0-1684396762981.png

 

NOTES:

1. limitation: solution works with sample input. Would need to include all of the permutations of address endings with a larger dataset