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
Alteryx

Here's my solution. I didn't want to retype all the Field Names in a Select so I have a few extra tools to grab the questions then just edited the first couple.

Spoiler
2019-05-01_23-26-42.jpg

 

Asteroid

oof, it turned out to be a monster for me... but it gets things done!

Alteryx Partner

My approaches a) Using nested macros--just because; b) Transpose+Crosstab + a good number of tools just to (dynamically) get the names right...

Spoiler
Image 001.png1. Two approachesImage 002.png2. Output of nested macrosImage 003.png3. Output of transpose+crosstab+renaming

 Still unable to upload files to the gallery... My approach is here: https://github.com/dsmdavid/Alteryx-Weekly-Challenge/tree/master/submitted/sub_Challenge%23112

Alteryx
Alteryx

This was a tricky one!

 

Week 112.PNG

Alteryx
Alteryx

This was a tricky one!

 

Week 112.PNG

Alteryx Partner

We tackled this problem at our monthly user group meeting yesterday and here is my solution. My emphasis here is on simplicity to show step by step transformations in the workflow.

AlteryxWC112 - Solution (WAILOR).PNG

Asteroid

We gathered yesterday for our Phoenix User Group to solve this challenge.

 

It looks like questions 1 & 2 have a similar format and need the column headers to be renamed; question 3 has the advantage of having the column header name already available. All other questions need to be first split using the colon as delimeter.

 

Spoiler
2019-06-19_12-27-15.jpg
Asteroid

My solutions

Meteor

my solution

Meteor

Ahh that makes so much sense, with your notes. I went the way to long super way around it, I now see where I can most definitely shorten this a ton. I usually try to get the solution done anyway anyhow without peeking at solutions, then go back and see how dumb I did it. But I guess that's how you learn.

 

survey.png