We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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

Towers
11 - Bolide

tried a bit too hard to get the column names on this one 😅

Spoiler
challenge 33.png

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Interesting ..

All the best,
BS

LinkedIN

Bulien
tristank
11 - Bolide

If someone gave me data like this we are throwing hands 😤

 

33.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
Reshaping Nielsen Data.png

Rachel Lynch
MatteoReddavide
8 - Asteroid

My solution

 

Spoiler
Screenshot 2023-07-24 164219.png
lwolfie
11 - Bolide

Struggled with seeing how the data was coming in more than how to separate it.

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Brute forced my way through this data. It's quite the manual solve rather than making it dynamic. Will revisit this one day to see if I can make it more efficient.

GabrielaTudor
8 - Asteroid
Spoiler
Challenge 33.jpg
jon_amanrich
8 - Asteroid

Challenge 33 solution below!

gawa
16 - Nebula
16 - Nebula

Done

Spoiler
image.png