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

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Parul_Kapoor
8 - Asteroid

Solution attached

grossal
15 - Aurora
15 - Aurora

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
ACE Emeritus
ACE Emeritus

Took a bit of a manual approach to this one. 

Spoiler
jarrod_0-1590604746303.png