We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #50: Preparing Survey Data

Colintermeer
8 - Asteroid

Answer

benjimoser
8 - Asteroid

My Solution

Spoiler
benjimoser_0-1676903434989.png

 

JoeChan619
8 - Asteroid

Solved.

Spoiler
challenge 50.png
ed_hayter
8 - Asteroid
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