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 #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
10 - Fireball

Solution attached

nivi_s
8 - Asteroid

Challenge #33 solved!

 

 

Spoiler

(A mildly hacky solution)

 

clipboard_image_1.png

 

ArnavS
Alteryx Alumni (Retired)

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