We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #23: Parsing CPG Data

Jean-Balteryx
14 - Magnetar

Here is my solution !

Parul_Kapoor
8 - Asteroid

Solution attached

grossal
14 - Magnetar
14 - Magnetar

Time to work on these challenges!

 

Spoiler
grossal_0-1586520268706.png

 

More tricky than expected.

 

 

steven4320555
8 - Asteroid

Good practice, and took two rounds of transpose and cross tab for me.

Spoiler
steven4320555_0-1586777185579.png

 

KevinTang
8 - Asteroid

Done

cc000072
8 - Asteroid

Too difficult..

Spoiler
WeeklyChallenge_Ryohei_23.JPG
CKP
10 - Fireball

I hope there's a prize for the longest solution, I might stand a chance. :-S

 

challenge_23_mysolution.jpg

DavidLane
8 - Asteroid

If I were doing this for real I would definitely wrap up the large centre container in a macro, but have left it out to show how everything works.

 

Spoiler
DavidLane_0-1590239294367.png

 

seinchyiwoo
Alteryx Alumni (Retired)
Spoiler
seinchyiwoo_0-1590546895196.png

 

jarrod
12 - Quasar
12 - Quasar

Took a bit of a manual approach to this one. 

Spoiler
jarrod_0-1590604746303.png