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
8 - Asteroid

Answer

benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1676903434989.png

 

JoeChan619
8 - Asteroid

Solved.

Spoiler
challenge 50.png
ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1677171330200.png

 

WernerE
8 - Asteroid

This is my solution to the challenge. 

Spoiler
50.jpg
Shahbaz_analyst
8 - Asteroid
Spoiler
Shahbaz_analyst_0-1677686134823.png

 

Nolan
7 - Meteor

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.

 

Spoiler
Nolan_0-1677686495213.png

 

Stieve2
5 - Atom
Spoiler
Stieve2_1-1677710566282.png
Dani_Lin
8 - Asteroid

solved

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1678328524721.png