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 after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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 #23: Parsing CPG Data

carmenrapariz
8 - Asteroid
Spoiler
Challenge 23.PNG
BobHaan
5 - Atom

Here is my solution.  I did it a little differently than the other solutions I have seen.  Please reach out to me if you have any questions

 

Spoiler
BobHaan_9-1627393027603.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 23.PNG
DanTh
Alteryx Alumni (Retired)
Spoiler
One hour later... I'm going to post my solution before looking at others', as I 100% know there is a better way of doing this and will end up kicking myself. Not elegant, but used a whole lot of Sample tools to make the data behave.

4/5
MatthewBr
Alteryx Alumni (Retired)

Lot of work to get this to align but doesn't surprise me that CPG data being in a un-consumable format.

MatthewBr
Alteryx Alumni (Retired)

CPG data in an inconsumable format.

ARussell34
8 - Asteroid

I'm glad I'm getting a better understanding of the Multi-Row Tool, but still had to look to the community for some guidance on this one.

Jotigautam
10 - Fireball

Amazing challenge and the toughest one i have solved till now.. Had to think a lot on logic building

MichelleL
Alteryx
Alteryx

Good practice!

BenFr
Alteryx Alumni (Retired)

Unleash all the building blocks!

Spoiler
BenFr_0-1632754152267.png