Weekly Challenge

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

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

Submit Feedback
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.

Challenge #112: Organizing Survey Data

Highlighted
Alteryx
Alteryx

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.

 Same, Kip....same.Same, 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.  

Highlighted
14 - Magnetar
14 - Magnetar

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

Highlighted
12 - Quasar
Spoiler
Challenge #112.PNG
Is there a way to do this with less parse tools? Always looking for a faster way 🙂
Highlighted
12 - Quasar

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

 

Spoiler
Challenge #112 v2.PNG
Highlighted
7 - Meteor
 
Highlighted
13 - Pulsar

Uploading my version of solution

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

Capture2.PNG
Highlighted
8 - Asteroid

I enjoyed this exercise.

 

Spoiler

 

Capture.PNG

 

Highlighted
8 - Asteroid
Spoiler
Weekly 112.JPG
Highlighted
12 - Quasar
12 - Quasar

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