Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

gawa
16 - Nebula
16 - Nebula

Upload solution file

SJKIM
8 - Asteroid

Completed.^^

MitchellBliesner
8 - Asteroid

This took a lot longer then I wanted it to. I need to practice more data prep. I also need to practice Regex.

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Tgigs
8 - Asteroid

My solution attached.

 

Had to peek at the solution to figure out what to do.

 

Added some commentary around the regex expressions to explain what it is doing and added a couple of extra steps to convert some data types at the end (specifically date and numeric types) so that the dataset is primed for analysis.

Tofel
8 - Asteroid
Spoiler
Challenge 33.JPG
danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-10-20 085844.png
afnfyz
8 - Asteroid

I couldn't figure out the pattern of the numerical values here, had too take a peek at a solution to find the pattern.
Once I knew which rows contained the data it all made sense.

Spoiler
Screenshot 2023-10-23 223337.png
DanielG
12 - Quasar

This was an anxiety-inducing dataset.  What I built solves the problem, but would not be the best solution for a dynamic situation where report structure might look different in a given timeframe.

 

Glad to wash my hands on this and mark it:

 

Solved.  😊

 

 

Carolyn
12 - Quasar
12 - Quasar

Solved! I had to peek at the solution to find where the data was since I was lost

 

Spoiler
2023-11-09_17-39-56.png