Challenge #50: Preparing Survey Data

[MarMu]

Fun challenge.

i wanted to challenge myself and make the headers dynamic, In hinsight, that probably wasn't the smartest move :)

Pretty tricky to parse the question as header, as it has special characters. I was planning on using the "Cross Tab"-tool, however the special character issue made that impossible. I came up with a work around using the "Dynamic Rename"-tool.

Spoiler

FYI, Five-O challenge solved!

[danrh]

Wasn't entirely sure what the expected output should be ... so I just matched the provided Output. Though personally, I would remove my last Select to get a more all-encompassing dataset ...

[pasccout]

Here is my solution... I reproduced the output required but don't understand why we need the questions data since only column 38 is important...

[StevenBetts]

Here's my solution :)

Spoiler

[kbwissi]

Done! Trickier than I initially thought.

[kelly_gilbert]

I had a terrible time with this one, until I realized that there is an issue with one of the inputs! See spoiler tag #1 for details. This was great practice for working on a variety of data prep tasks!

Spoiler

The Age question is listed as column #28 in the Questions input, but it is actually in column #38 in the Data.

The question about search experience is listed as column #38 in Questions, but it is actually column #48 in the Data.

In the given solution, the value shown in the "Please tell us..." column is actually the numeric portion of the Age response.

Spoiler

[JoshuaGostick]

I've worked with survey data a lot so really enjoyed this one despite the issues with the solution output as mentioned by others.

Spoiler

[Kenda]

Spoiler

[jbranaum]

My Solution