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

PrivateStorm
8 - Asteroid

Here is my solution.

kcoulon
8 - Asteroid

Not quite the same as the solution provided but...Challenge Solved!!

StevenBetts
8 - Asteroid

This felt a bit brute force-y but I got the correct result, so I'm not mad about it ;)

 

Spoiler
Challenge 33.jpg
StevenBetts
8 - Asteroid

Double post - sorry! 

justynam
8 - Asteroid

My solution :-)

CaraI
Alteryx
Alteryx

What a way to kick-off the weekend with a revisit of my 'love-hate' relationship with RegEx.  

Spoiler
It took me a while to even find the data to know what to hunt for in the data set, and then messing around with the RegEg Match function in the RegEx Parse just to get the syntax right and then put that into the multi-row tools.

33 workflow.jpg

 

danilang
19 - Altair
19 - Altair

My Solution

 

 

Spoiler
Solution 33.png

Dan

 

arein0
8 - Asteroid
 
OldDogNewTricks
10 - Fireball

This solution wouldn't generalize well, but it get's the job done!

 

Spoiler
I think this is a unique way to use the generate rows tool here.  Gets the job done for this nasty file; but not the next nasty file if it is not structured exactly the same.


challenge_33_completedScreen.jpg

 

kat
12 - Quasar
Spoiler
Challenge #33.PNG