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

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 33 is done!

 

Spoiler
challenge 33 JMS solution.PNG
ConradW
8 - Asteroid

33 - complete

DanielMS
Alteryx
Alteryx
Spoiler
Capture.PNG
tammybrown_tds
8 - Asteroid

Yikes!  This one was h.a.r.d.  I had to peek at other solutions to make mine work.

 

Good luck to others!!

ydmuley
12 - Quasar
12 - Quasar

Once again different from most of the solutions. But really liked some of the solutions from others where the column names were directly sourced from the data and not by re-naming.

 

Used simpler methods to solve this challenge.

 

The solving thrill continues!!!!!!!!!!!!!!!!

 

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good Evangelist |

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
JennyMartin
9 - Comet
Spoiler
AWC33.PNG

Tricky data prep exercise.

mbogusz
9 - Comet

@TaraM that is so cool you can do a REGEX in a filter vs. formula + filter

Spoiler
2019-09-22 20_20_51-Greenshot.png
BSilverblatt
8 - Asteroid

Thanks for the challenge! This is my solution.

ArnavS
Alteryx
Alteryx
 
meeravijayan2011
8 - Asteroid
Spoiler
SPOILER

33 solution.png