In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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 #20: List Parsing

acarter881
12 - Quasar

Here's my solution. Ended up having to use someone else's solution. I was fairly close, but so many one-off cases that were too difficult to put into a formula.

Spoiler
my_weekly_challenge_20_solution.png
jay_char
8 - Asteroid

A good one!

martinding
13 - Pulsar
Spoiler
20.png

This one has taken me much longer than expected, and my solution is very close there but still not yet perfect.

I feel that I need to spend a bit more time on exploring some of the edge cases.

Supergiant
8 - Asteroid

Nice fun with Regex!

Spoiler
Supergiant_0-1665999486607.png

 

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1666208056231.png

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1666350620833.png

 

Kinga
8 - Asteroid

Hi,

 

Please find my solution below

 

Spoiler
Kinga_0-1666625744772.png

 

leonhekkert
8 - Asteroid

Took me way to long.. But therefore a good learning experience.

 

Spoiler
Challenge 20.png

 

 

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1667406087989.png

 

I wanted to add a couple of multi-row tags to make parsing a little more failsafe but the next logical tag just kept appearing and it got messy. Happy to get it pretty bang on though

DataNath
17 - Castor
17 - Castor

My solution to #20. Missed a few phone/address edge cases but more than happy getting all records and 100% matches for all but 2 fields.

 

Spoiler
DataNath_0-1667508862746.png