ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

apathetichell
20 - Arcturus

I'm not 100% comfortable with the answer provided - but that's what I got once I limited myself to the first 30 records. regexed out the fieldnames but they were so useless that I ended up hardcoding them anyway.

 

I remember nielsen ratings to my old college radio station... by fax. They were slightly easier to read than this.

Gopi_Krishna_Bandi
8 - Asteroid

Hi,

 

PFA my solution

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1617049819226.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1619103208718.png

 

Cheers!

Phil

meghanarang
6 - Meteoroid

Interesting challenge

Erin
11 - Bolide
Spoiler
Was trying to get away from manually updating the headers in the last join, but adding the age classification to the headers stumped me. Just seemed more efficient to add manually in the join after all. 
dmceleney
7 - Meteor

completed

RashedDS
8 - Asteroid

My solution

Spoiler
RashedDS_0-1626541235468.png

 

JackBurnham
8 - Asteroid

b

Elias_Nordlinder
11 - Bolide

Here is my solution:

 

Spoiler
Elias_Nordlinder_0-1626962344224.png

 

Elias_Nordlinder_1-1626962375082.png