Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe instructions were a little bit confusing in terms of how they wanted us to select columns but I feel like I finally figured it out.
The "Advanced" part of this challenge is figuring out what it is really asking for. To make this dataset useful, each row of response data needs to contain or be able to lookup via joins in Tableau, Qlik, PBI, etc... I could replicate the apparent error in the challenge data shown as "Output" but this doesn't seem useful as the prompt shown does not correspond to the question asked. I added an age to every response by parsing column 38 to get the age range. Then i looked up the prompt in the Questions file and added that to every record and output a tall dataset, suitable for tableau, and a wide dataset suitable for excel. I spent more time reviewing the challenge and the various solutions that people have tried to interpret from the challenge... This is the first challenge i've come across where i spent more time figuring out what to do than how to do it. Maybe worth a review of the prompt for the challenge? or maybe worth a few hours off the computer (for me, i mean!) Thank you.