The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

leonhekkert
8 - Asteroid

My solution!

 

Spoiler
Challenge 54.png
JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1646920141025.png

 

Only learned RegEx yesterday so couldn't work out the city part. Ended with some very ugly logic which I'd be surprised if anyone else had to resort to.

RobbieA
8 - Asteroid

My solution for challenge 54

Spoiler
RobbieA_0-1646924822033.png

 

DataNath
17 - Castor
17 - Castor

My solution to #54. Pretty 'brute-forcey' but seems a lot of responses have extra inputs etc. to compensate.

 

Spoiler
DataNath_0-1646929124383.png

 

benjamin_feuchter
8 - Asteroid
Spoiler
benjamin_feuchter_0-1648033924075.png

 

James_Driver9
8 - Asteroid
Spoiler
James_Driver9_1-1648141239283.png

 

Diederik_vanderharst
8 - Asteroid

Voila

 

Spoiler
Schermafbeelding 2022-03-24 om 20.01.49.png

alfredcsy
8 - Asteroid

alfredcsy_0-1648392492216.png

 

DeanLewis
8 - Asteroid
Spoiler
DeanLewis_0-1648549268502.png

 

DanielvanLeuzen
9 - Comet

my solution