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 #33: Reshaping Nielsen Data

Cosmin_S
8 - Asteroid

Solution attached (similar to other solutions around here).

Thank you. 

LukeG
Alteryx Alumni (Retired)
Spoiler
Challenge_33_LG.PNG

Here's my solution. Not as dynamic as it could/should be

bnelly1987
8 - Asteroid

Pretty Tough. Hard to reshape data when you have no idea what most of it means.

Spoiler
Solution-Challenge 033.PNG
fmeo
8 - Asteroid
Spoiler
33.PNG
David-Carnes
12 - Quasar

It took me two sessions of staring at the data when I found the easy way to gather it.  Of course, I then had to make it difficult by deciding to programmatically create the column headers for the numeric data. I have never strung this many Multi-Row tools together in a row.

 

Spoiler
033.png

 

FRANCK_ROUQUETTE
8 - Asteroid

Thank you for the exercise - find attached my proposed solution

jagdeep_singh85
8 - Asteroid

PFA my solution

MattBenj
9 - Comet

Solution attached

nivi_s
8 - Asteroid

Challenge #33 solved!

 

 

Spoiler

(A mildly hacky solution)

 

clipboard_image_1.png

 

ArnavS
Alteryx
Alteryx

Completed by brute force. Will update with a more dynamic solution when I figure that out