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

myastarling
10 - Fireball

I'm slowly befriending Regex... This was pretty fun!

Greg_Murray
12 - Quasar

Solution attached

garthn555
8 - Asteroid
Spoiler
gn_challenge_33.png
PhilBalderson
8 - Asteroid

Quick and dirty. Sure there's a better way to extract column headers... 

Shaun_Rheeder
8 - Asteroid

Many filters were used but I got it.

hanykowska
11 - Bolide

this is not pretty... but it works

Johnny_Analytics
8 - Asteroid
Spoiler
This is one where I'm sure I'll see an easier way!  Still - got there in the end. 🙂

Challenge_33.png
RWvanLeeuwen
11 - Bolide

Here's my hacke tacky not so fine solution, but it should work with additional weeks (unlimited) but it requires the same field name structure and amount or it will break

Spoiler
33.png
CliffordC
Alteryx Alumni (Retired)
 
TonyaS
Alteryx
Alteryx

It's not pretty, but neither was the input data. There is a typo in the Output - P25-34Consume should be P25-54Consume. 

Tonya Smith
Sr. Technical Product Manager, cloud App Builder