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
This one baked my noodle a bit, and the workflow is probably one of my messiest for a while, but here goes:
Spoiler
I started by dropping the extra columns and splitting the data using the "Select Records" tool. Here, I selected in one stream the question and answer rows for the first three questions, and on the second selector I did the same for the last questions that are in a different format, and transposed each stream into a single column. The second stream, I parsed to rows on the ":", I then unioned the steams back together:
This put all questions and answers into the same alternating format.
From there it was a simple case of creating a Question/Answer column, and using the "Make Columns" tool to create a column for the question and answer on the same row.
Then I simply cross-tabbed the data and cleaned up. The last step being a dynamic rename to replace the underscore in the titles.
This put all questions and answers into the same alternating format.
From there it was a simple case of creating a Question/Answer column, and using the "Make Columns" tool to create a column for the question and answer on the same row.
Then I simply cross-tabbed the data and cleaned up. The last step being a dynamic rename to replace the underscore in the titles.
