community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #112: Organizing Survey Data

Highlighted
Sr. Instructional Designer
Sr. Instructional Designer

A solution to last week's Challenge has been posted here!

 

This week's Challenge really should be called "From Data Preparation Nightmare to Sweet Survey Dreams: Inspired by a True Story".  After sending out a survey, I received the results in a format that made me shudder.  But then, I remembered: I have Alteryx.

 yesssss.gifSame, Kip....same.

 Because I had so much fun with this real-life Challenge, I thought it might be right up your alley, too!  The input data contains the survey responses from conference attendees.  Parse and organize the provided survey data so that each survey responder's first name, last name, occupation industry and conference requests are aligned in a single record.  

My solution! Interested to see who can come up with some smaller-number-of-tools solutions... mine seemed a bit lengthy.

 

Spoiler
WeeklyChallenge112.JPG

Cheers,

NJ

Quasar
Spoiler
Challenge #112.PNG
Is there a way to do this with less parse tools? Always looking for a faster way :)
Quasar

Took a second look and made it a lot more efficient. And finally used regex in formula!

 

Spoiler
Challenge #112 v2.PNG
Meteor
 
Quasar

Uploading my version of solution

Spoiler
Napoleon was left out of the data set so I just included his picture at the bottom.

Capture2.PNG
Asteroid

I enjoyed this exercise.

 

Spoiler

 

Capture.PNG

 

Asteroid
Spoiler
Weekly 112.JPG
Bolide
Bolide

Got it!  ... but I'm guessing there is a way to do it in fewer steps!