The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
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
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

Towers
11 - Bolide
‎06-27-2023 06:04 AM

tried a bit too hard to get the column names on this one 😅

Spoiler
challenge 33.png

 

challenge_33_towers.yxzp
Reply
0 Likes
BS_THE_ANALYST
15 - Aurora
15 - Aurora
‎06-27-2023 06:09 AM

Interesting ..

All the best,
BS
LinkedIN

Bulien
challenge_33_BS.yxmd
Reply
0 Likes
tristank
11 - Bolide
‎06-29-2023 02:30 PM

If someone gave me data like this we are throwing hands 😤

 

33.png

 

challenge 33 completed.yxmd
Reply
0 Likes
rachel_lynch
Alteryx
Alteryx
‎07-05-2023 10:42 AM
Spoiler
Reshaping Nielsen Data.png

 

Rachel Lynch
Reshaping Nielsen Data.yxmd
Reply
0 Likes
MatteoReddavide
8 - Asteroid
‎07-24-2023 07:43 AM

My solution

 

Spoiler
Screenshot 2023-07-24 164219.png
challenge_33_start_file.yxmd
Reply
0 Likes
lwolfie
11 - Bolide
‎07-24-2023 12:20 PM

Struggled with seeing how the data was coming in more than how to separate it.

challenge_33_solution_LW.yxmd
Reply
0 Likes
H_a_n_g_C_h_e_n__x3
8 - Asteroid
‎07-27-2023 07:48 AM

Brute forced my way through this data. It's quite the manual solve rather than making it dynamic. Will revisit this one day to see if I can make it more efficient.

challenge_33_complete 7-27.yxmd
Reply
0 Likes
GabrielaTudor
8 - Asteroid
‎08-02-2023 04:34 AM
Spoiler
Challenge 33.jpg
challenge_33_G.yxmd
Reply
0 Likes
jon_amanrich
8 - Asteroid
‎08-03-2023 02:15 AM

Challenge 33 solution below!

challenge_33_solution Jon.yxmd
Reply
0 Likes
gawa
16 - Nebula
16 - Nebula
‎08-19-2023 09:15 PM

Done

Spoiler
image.png
Reply
0 Likes