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 #50: Preparing Survey Data

Colintermeer
Astéroïde

Answer

benjimoser
Comète

My Solution

Révélation
benjimoser_0-1676903434989.png

 

JoeChan619
Astéroïde

Solved.

Révélation
challenge 50.png
ed_hayter
Pulsar
Révélation
ed_hayter_0-1677171330200.png

 

WernerE
Astéroïde

This is my solution to the challenge. 

Révélation
50.jpg
Shahbaz_analyst
Astéroïde
Révélation
Shahbaz_analyst_0-1677686134823.png

 

Nolan
Météore

Here is my solution! I double checked my output and it is the same as the output in the solution file - no joins or cross tabbing required.  The "Age" question in the "Questions" input (row 28) does not return age response values, and in the solution file, the "Search_Experience" column is just parsed twice and the "Age" column is never used anyways. I was able to build my own version of the solution involving joins and cross-tabbing to pull column headers, but I still think this question was a bit unclear. Perhaps folks in this thread have a better understanding of this question and could clarify.

 

Révélation
Nolan_0-1677686495213.png

 

Stieve2
Atome
Révélation
Stieve2_1-1677710566282.png
Dani_Lin
Astéroïde

solved

CeliaC_Silje
Astéroïde
Révélation
CeliaC_Silje_0-1678328524721.png