Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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