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

Maskell_Rascal
13 - Pulsar

Wow! This one took a lot of trial and error before finally getting the correct output. Fun challenge!

 

Spoiler
Maskell_Rascal_0-1618948907675.png

 

Cheers!

Phil

ENix
8 - Asteroid
Spoiler

ENix_0-1620252528503.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1621623866072.png

 

bjkay30
8 - Asteroid

Wow, this was a headscratcher.  Spent way too long on it, and had to look for a couple of hints, but glad I finally got it.

 

Spoiler
bjkay30_0-1622122706775.png

 

RashedDS
8 - Asteroid

My solution for Week 20.

I enjoyed trying RegEx.

Spoiler
Week20.JPG

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Great challenge on regex, spend a whole day yesterday to finalise this challenge!

TKSnider
8 - Asteroid

Ok, I found this one to be a really rough one...  the programmer in me struggled to find any pattern in the data...

 

Spoiler
I won't say it is perfect...  it was hard to validate back against the source, but I did notice I teased some phone numbers out of the data that were not done in the validation set.  I think the difference in my count vs the validation is because of some duplication in the two datasets but when I matched them up by company name and phone number, I came out with the same 1742 count and the 4 that bounced out on either side was due to me pulling the phone number out of the address where the validation didn't.

I will have to go back and really study the official solution on this to find out if I was anywhere NEAR right...  which I doubt 🙂
Ajjay
8 - Asteroid

Soln

cwkoops
8 - Asteroid

There's got to be an easier way...also may only be close and not exact.  

MichelleL
Alteryx
Alteryx

Did it without peeking!  Whew!