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

MaxGiegerich
8 - Asteroid
‎08-17-2018 01:11 AM

Regex to the rescue again! 

Weekly Challenge #33 MG.yxmd
Reply
0 Likes
Kenda
16 - Nebula
16 - Nebula
‎08-22-2018 11:34 AM
Spoiler
33.PNG
challenge_33_start_file.yxmd
Reply
0 Likes
MarMu
8 - Asteroid
‎08-28-2018 02:05 PM

 

It took a while to figure out the parsing logic for the data and "In-Tab" turned out to be the hidden key :)

 

Spoiler
challenge_33_start_file_MarMu.png
challenge_33_start_file_MarMu.yxmd
Reply
0 Likes
OllieClarke
16 - Nebula
16 - Nebula
‎09-04-2018 06:02 AM

spent a while on this one. This solution doesn't use many tools, but feels a bit manual to me...

Spoiler
challenge 33.PNG
challenge_33_OC_solution.yxmd
Reply
CHarrison
8 - Asteroid
‎09-08-2018 06:31 AM
 
Challenge 33.yxmd
Reply
0 Likes
Walsh67
8 - Asteroid
‎09-13-2018 06:43 AM
 
challenge_33.yxmd
Reply
0 Likes
lainecaruzca
8 - Asteroid
‎09-17-2018 07:18 AM

Here is my solution

 

 

challenge_33_start_file.yxmd
Reply
0 Likes
soha-elghany
8 - Asteroid
‎09-17-2018 07:20 AM
Spoiler
spoiler

ch33.png
ch.33 reshaping data using regex.yxmd
Reply
0 Likes
AlexanderF
6 - Meteoroid
‎09-17-2018 07:36 AM

Here is my solution:

Spoiler
33-af.png
challenge_33_start_file-AF.yxmd
Reply
0 Likes
JoBen
11 - Bolide
‎09-21-2018 07:43 AM

Cheers!

challenge_33_Joben_Solution.yxmd
Reply
0 Likes