community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #112: Organizing Survey Data

Alteryx Partner

My solution! Its cool to see how many different ways people accomplished this!

 

 

Meteoroid
Spoiler
Alteryx_112_output_2.PNG

Workflow works even if there is no input for questions like First Name, Last Name ......

Sr. Instructional Designer
Sr. Instructional Designer

@Rachel_B, I agree!  Even my solution (which I'll post next Monday...no judgement on the number of tools it took me to solve, please!) is so different from any solution submitted so far.  I'm loving all the variety and creativity here! 

Probably a few too many tools but stream-of-consciousness type development got me this:

 

Spoiler
challenge_112.PNG
Alteryx Certified Partner

Challenge 112 resolved

Spoiler
Workflow.pngWorkflow
Alteryx Partner

Capture2.JPG

Nice Exercise, I can't wait to learn the simple approach.

 

Pulsar
Pulsar

Wanted to create a workflow that wouldn't require manual selecting and renaming with a Select tool (see @JoeM, I do use other tools). 

Spoiler
First steps were to standardize the data, so that one row is the question, and the next row provides the answer. This involved 2 steps. 1) remove the rows that are just Q1, Q2, etc., and 2) standardize the rows with the question and answer blended together.

For 2, I separated out just those rows (qualified by "H" in the formula tool early on in my workflow) and stacked them on top of each other with a Union. 

I then used a Multi-Field formula tool to fix all of the columns (remove the "What is your", use title case, separate the questions in the rows cited as 2) above into just the question and just the answer. This was a bit of a convoluted IF THEN ELSEIF, but it worked well, and one tool only!

One more dynamic select to choose just the F1, F2, etc. columns. Then the same process as many others. Assign a record ID, transpose the data, crosstab it into columns.

Separated the questions from the answers with dynamic select, Unioned back together, and renamed with Dynamic rename.

And there you have it. A way to dynamically choose columns, rename columns, etc., without manual work in a Select tool.image.png
Sr. Instructional Designer
Sr. Instructional Designer

@EstherB47 the Dynamic Select tool is one of my favorites! :) 

Pulsar
Pulsar

@ChristineB Me too!!! It's like Filter for your columns. I love using (and teaching) it.

Asteroid

My solution :)