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

T_Willins
14 - Magnetar
14 - Magnetar

Completed, but seemed complex way for a simple parse.  IRL would likely not join questions, just rename, parse and output.

 

Spoiler
 Workflow 50.GIF

 

 

pedrodebs
7 - Meteor

My solution!

Suzu
9 - Comet

Here is my solution.

Thableaus
17 - Castor
17 - Castor

Challenge #50, done.

 

Spoiler
Challenge_50.PNG

Cheers,

hanykowska
11 - Bolide

It seems that the Questions lookup table is not correct: Age is for the 28th column, not 38th which is what is in the Data...

I did get the same results but also started working on an alternative solution that could actually allow creating a dashboard in Tableau or any other visualisation tool.

 

Spoiler
image.png
bkclaw113
9 - Comet
 
jyotijyoti_dup_475
8 - Asteroid

Hi Guys,

 

I have used Dynamic Rename and Text to columns stages. I am not sure if its an efficient workflow..Suggestions are welcomed.

 

Thanks,

Jyoti

TimothyManning
8 - Asteroid
Spoiler
50. Data Analysis.PNG

Got myself really confused by the question and the output, but got it in the end quite simply

Eleonora
8 - Asteroid

My solution

 

Spoiler
challenge 50 solution Eleonora Nazander.JPG
RobertoEstrada
8 - Asteroid

My response attached; it looks like the responses on columns 28 and 38 are swapped; so I got a different answers as the one posted.