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.

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

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

 

  • This challenge passes off as a great learning point if you are trying to understand what a full cartesian join is!
  • Append fields has a really amazing application incase you are trying to duplicate records
Spoiler
Solution_270.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 270.PNG
KilianL
Alteryx
Alteryx

Permutations in Alteryx!

Glad that we have a function like "[A] not in ([B],[C],[D])" to save some copy-paste.

 

Spoiler
270 - Pony Permutations - Kilian.png
Elias_Nordlinder
11 - Bolide

Soo, I guess there's more than one way to skin a horse?

 

Spoiler
Elias_Nordlinder_1-1626283861989.png

 

cwkoops
8 - Asteroid

!!  + Credit

1) Append

2) Generate Rows

 

Third method would leverage a macro?

 

 

ywang7
7 - Meteor

 

Spoiler
ywang7_0-1626472097088.png

For 5 horses, there will be 5! = 120 possible outcomes.

 

ddiesel
12 - Quasar

My solution:

 

Spoiler
Capture.PNG
aruiz-itp
11 - Bolide

here is the solution 

phottovy
12 - Quasar

I decided to mix this one up a little. I created an iterative macro that simulates a user defined number of races. You can also add win percentages to skew the simulations:

 

Spoiler
Balanced Results:
270 Balanced.png

Weighted results (Speedy had a 50% chance of winning):
270 Skewed.png
RWvanLeeuwen
10 - Fireball

The combinatorial part of math has never been a favourite of mine... Neither are horses

Spoiler
270.png