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

dpencheva
8 - Asteroid

Here is my solution. The task was very interesting like a puzzle!

PeterH23
8 - Asteroid

My solution

Spoiler
What a crazy data format.

Challenge#33.png
joshuaburkhow
ACE Emeritus
ACE Emeritus

A good reminder to study the data first. Like others, spent time going down a rabbit to realize there is an easy way

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
steven4320555
8 - Asteroid

Overwhelmed by the messy data. It helped to go through some solutions, and as well as export the data into an excel. Got a solution at the end.

Spoiler
steven4320555_0-1586968800356.png


I cheated/copied the well-structured part from the browse tool.

steven4320555_1-1586968878122.png


Exported the input data into excel, and observed the structure of the data, and figured out the logic of using Regex match ^\(\d\/\d\d\/\d\d\)   to get the date, and the line above with data. Actually  ^\(.*\) was able to do the job. 

 

steven4320555_2-1586968986038.png


Familiarity with the structure of data will definitely help with such a problem.

 

AMansour
11 - Bolide

Hi,

 

Here's my solution 

 

Spoiler
Capture d’écran 2020-04-24 à 16.19.09.png

Cheers

Amr

terry10
11 - Bolide

Messy input data. It took me awhile to wrap my head around the task. 

 

Spoiler
ss 33.PNG
Sylvana
8 - Asteroid

My solution.

deepaprash
8 - Asteroid

Solved. Took more time to understand the layout of the raw data.

cc000072
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_33.JPG
Normster
8 - Asteroid

My solution was a little longer because I dynamically updated header names.  I see that a few others took the same approach.

 

Normster