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 #64: Catch Me If You Can

Alteryx Certified Partner

Solution attached. Got stuck on my first attempt.

 

Spoiler
challenge_64_spoiler_KO.png
Alteryx Partner

Here's my solution, looking through other people's solutions, I clearly over complicated things

Spoiler
Challenge 64.PNG
Highlighted
Asteroid

I don't know why the Crosstab tool mangles the column name strings, but otherwise here's my solution.

Fun dealing with the special characters and cross-tab tool.  I'll have to check some other solutions and see how others dealt with this problem.

 

Spoiler
challenge_64_completed.jpg

 

 

Bolide

Cheers!

Alteryx Certified Partner

Very cool macro to continually randomize the inputs!

 

 

Asteroid

 

Pretty tricky challenge. Very hard to debug column sorting. I feel like I've tried every combination of sorting and re-ordering before I re-read the description. I absolutely killed it with the Dynamic Select tool. Such a simple solution. It brought the no. of tools down to 3.

 

It's a bit annoying that the shuffle-macro is locked for editing and I cannot rename the file to match (my made up) naming convensionrest of the other weekly challenges. Why?

 

Anywho. I made it, yay me

 

Spoiler
challenge_64_start_file_MarMu.png
Asteroid

Here is my solution

Asteroid

My solution

Alteryx Certified Partner

One of my all time faves!