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

martinson
11 - Bolide

Tough question

Cheers,
martinson

LinkedIN

Bulien
Dhrish
8 - Asteroid
Spoiler
Capture.JPG
Dominic_Brady
8 - Asteroid

The actual solution isn't too bad.. hard part with these is understanding what on earth the initial data format is!

TGreen
8 - Asteroid

Solution submitted.

JBevan89
8 - Asteroid

My Solution attached.

Bennu
8 - Asteroid

1 toll only solution.. doesn't get easier than that...

Spoiler
WC_033.jpg
RebekaMazuchova
8 - Asteroid

:)

 

Rhys_Cooper
11 - Bolide

Brain tickler to workout the pattern of the input data. Good reminder of the importance of taking your time reviewing data before keyboard smashing out a solution! Thought the final step of manually relabelling the fields in a select tool is undynamic so made a better solution to fix that.

 

Spoiler
Screenshot 2025-06-06 092235.png
Pilsner
13 - Pulsar

My solution:

Spoiler
33.png

jrlindem
11 - Bolide

Felt like this one's solution file took some liberties due to familiarity with the data file, but hey, we've all been there too right?

 

Spoiler
jrlindem_0-1755833039228.png