We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #112: Organizing Survey Data

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_112_RODO_Solution.png
dholle1958A
7 - Meteor
 
justindavis
9 - Comet
Spoiler
challenge_112_solution_justindavis.PNG
SueDonim
8 - Asteroid

Took me a bit of thought to figure this out without too much brute force.  Got a bit more clever on my Transpose and Cross-tabs than in the past

 

Spoiler
Process:
- Select tool to get rid of the unneeded fields
- Select Records to obtain just the responses
- Record ID to be able to identify individual responses
- Transpose on Record ID
- Text to Columns on ":" delimiter
- Created "Item" fields to use as field name
- Formula to create "Respondent" ID from Name (e.g. extract number from "F2", etc) - that was because the order of my data came out wrong since Name is a text field
- Formula to update "Value" field so it holds all responses to questions
- Cross-Tab on Respondent with Item as column header and Value as data
- Clean-up

MySolution.PNG
echuong1
Alteryx Alumni (Retired)

Seems a little messy, but there was a lot of cleanup to be done! 

 

Spoiler
echuong1_0-1575665748270.png
sachinw
8 - Asteroid

My Solution:

DataTester
8 - Asteroid
 
JamesCameron
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1579020656647.png
rmassambane
8 - Asteroid
 
danicahui
8 - Asteroid
Spoiler
Challenge 112 2020-01-21.jpg