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

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1678723747650.png

 

Towers
11 - Bolide

i got the same answer but I may have misunderstood the prompt, not sure

Spoiler
Towers_0-1679054732065.png

 

PeterHajnal
8 - Asteroid

.

LHolmes
9 - Comet

Found the data-question connection interesting as the response looked more like a number for the age category - but still fun to link everything together!

 

Spoiler
050 - Solution.PNG
Hammad_Rashid
11 - Bolide

WeeklyChallenge50.JPG

DanielG
12 - Quasar

this one was just plain annoying....  😀

 

solved

Shifty
12 - Quasar

I think I'm missing something but I did get the answer. 😝

 

Spoiler
Shifty_0-1681495459784.png

 

HardikJani
7 - Meteor

Fun challenge to solve. Used the text to column to parse age. Used the append tool followed by cross tab to get to get rating for each question and selected only the required columns then used the find and replace to look up with respondant ID. 

Spurs
8 - Asteroid
Spoiler
Spurs_0-1681917130931.png

 

Ray_Pospisil
8 - Asteroid

I could see many people using FILTER tool (thus, manual change of parameter). I did the same and all other tools I had to use were APPEND , REGEX , DYNAMIC RENAME and SELECT