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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #11: Identify Logical Groups

Asteroid

My solution:

 

Spoiler
workflow.JPG
Alteryx Partner

Glad to see simpler ways of doing this one than how I got to it!

Spoiler
2018-12-21_14-50-45.png
Alteryx Partner

At first, I was trying to use the find and replace tool! But soon, found the append tool the most useful!startfie11.PNG 

Asteroid

This was fun to solve!  Harder than initially expected.  I ended up building the workflow with a subset of the data because even accessing it took awhile on my poor little computer.

 

Spoiler
011EW.PNG
Meteor

My solution runs in 12.8 secs. Not sure if it's the most efficient but definitely works. 

Meteor

Really liked your solution!

Asteroid

My Solution Attached. 

Highlighted
Alteryx Partner

Preview of the worklfow:

Spoiler
workflow.PNG

Results:

Spoiler
results.PNG
Alteryx
Alteryx

Had some trouble with this one, but @MichalM helped with the idea of giving each incident a record ID and parsing into rows. Definitely a useful skill to have!

Asteroid

my solution, similar to others