Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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.
