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

Jude451
8 - Asteroid

I enjoyed this challenge. Thanks!

brandon_bunney
8 - Asteroid

Attaching solution for challenge #20

Hub119
12 - Quasar
12 - Quasar

Solution attached.

robert-headington
8 - Asteroid

#20

zkibz16
7 - Meteor

See attached for a Challenge #20 solution

rcarog
8 - Asteroid

Solution attached.

apathetichell
20 - Arcturus

This one was just brutal... Couldn't make heads or tails on how to effectively split this and create ids and finally got 1739 or the 1742 and  had to fudge the others by hardcoding exceptions... Curious to see what regex magic I missed out on...

AllexJia
8 - Asteroid

Did I miss something? I was confused by the way how I could get the pattern of the data?

KilianL
Alteryx Alumni (Retired)

That is some messy data coming in. A bit of RegEx practice later, it becomes a nice table!

 

Spoiler
This needed a 'rule check' Filter to make sure my RegEx captures all information.
020 - List Parsing - Kilian.png
meghanarang
6 - Meteoroid

Here is my submission.

As a beginner I found this challenging yet interesting. I had to refer to the solution sheet, however, learned a lot.

 

Thanks,

M