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

AndrewSu
Alteryx
Alteryx

my attempt :)

 

 

sgreenough
8 - Asteroid

Solved.

TonyAndriani
9 - Comet

Reposting under my new user ID.

Shifty
12 - Quasar

Skipping the first few rows takes me back to SAP in 2005. 

Spoiler
Shifty_0-1651210314107.png

 

 

mgaronson
11 - Bolide

Actually starting to understand RegEx. By tomorrow, I'm sure I will have to start over with RegEx. Haha! Big fan of the multi-row formula tool. Funny that the RegEx tool shows the red ! point when I open the workflow - it resolves itself when run.

binuacs
20 - Arcturus
Spoiler
binuacs_0-1651467954389.png

 

usmanghayoor
8 - Asteroid
Spoiler
usmanghayoor_0-1652955085163.png

 

m-wolters
8 - Asteroid

My solution

FCCMac
7 - Meteor

These are still tricky for me, I had a hard time wrapping my head around what the report was actually telling me...

Jon-Knepper
8 - Asteroid
Spoiler
JonK_0-1653581129385.png

 

This one was fun!