Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

estherb47
15 - Aurora
15 - Aurora

Another solution, without the need to rename fields manually. This workflow, though long, finds, formats, and assigns the header row.

LordNeilLord
15 - Aurora

I went down a rabbit hole with this one trying to be too clever and then realised there was a much simpler solution...

 

Spoiler
Weekly Challenge 33.png
nick_ceneviva
11 - Bolide

Probably not the best way to go about it but got the solution!

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
Natasha
9 - Comet

I feel like my solution is not long, but very cumbersome

 

Spoiler
Screen Shot 2017-10-28 at 13.28.39.png
dominiklz
8 - Asteroid
Spoiler
33.PNG

not very pretty and I lost some coloumn names in the process, but somehow got there...

samN
10 - Fireball

Pretty Simple reformatting and configuring

ggruccio
ACE Emeritus
ACE Emeritus

It helped to look at the file in excel first to understand how it was structured....

PhilipMannering
16 - Nebula
16 - Nebula

Could have reduced the tools by having the data 'flags' in the filter itself. Solution attached.

 

Spoiler
challenge_33 - Snip.PNG
jasperlch
12 - Quasar

Solution attached.