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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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 #270: Pony Permutations

caitlynmcintyre
7 - Meteor
Spoiler
caitlynmcintyre_1-1623395244163.png

 

baby's first challenge 😕

 

DawnDuong
12 - Quasar
12 - Quasar

The "static" solution is easy enough, but the "dynamic" solution took me longer than expected. It's a good challenge to refresh knowledge of the dynamic tool. Thank you @mst3k  for submitting this challenge.

Jean-Balteryx
15 - Aurora

Here is my solution !

kelly_gilbert
12 - Quasar

I went with an iterative macro to dynamically handle different numbers of horses.

 

Spoiler
Extra credit:
The number of possible outcomes is n! (n factorial). So, if there were five horses, the number of outcomes would be 5! = 5 x 4 x 3 x 2 x 1 = 120.


Outer workflow:

kelly_gilbert_1-1623555247250.png

 


Iterative macro:
This seems way too long to do something so simple, however, removing the duplicates (e.g. horse 1 = horse 2) after each iteration was MUCH faster than removing them after all of the iterations completed (because those unnecessary records multiply quickly!)

kelly_gilbert_0-1623555107685.png
Assaf_m
11 - Bolide

My Solution Attached

 

 

Spoiler
Assaf_m_1-1623656167059.png

 

Pkoziol
6 - Meteoroid

Simple solution. It can be enhanced with Loops and Indexing to be dynamic and more robust.

Spoiler
Pkoziol_0-1623664962117.pngPkoziol_1-1623665172452.png

 

 

TonyAdam
8 - Asteroid

The extra credit was easy, but I though and hoped there would be a more elegant solution to the main task... :S

 

Spoiler
tonyadam_0-1623689768820.png


Extra credit: 5! = 120, n!

rmassambane
9 - Comet

With his brim pulled way down low

millerbp
7 - Meteor
Spoiler
Capture.PNG
JLdG
6 - Meteoroid

Had to get some inspiration from others for this one

 

 

Spoiler
JLdG_0-1624348511364.png