Challenge #270: Pony Permutations

[dhavaldoshi]

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

[carmenrapariz]

Spoiler

[KilianL]

Permutations in Alteryx!

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

Spoiler

[Elias_Nordlinder]

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

Spoiler

[cwkoops]

!!  + Credit

1) Append

2) Generate Rows

Third method would leverage a macro?

[ywang7]

Spoiler

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

[ddiesel]

My solution:

Spoiler

[randreag]

here is the solution 

[phottovy]

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:


Weighted results (Speedy had a 50% chance of winning):

[RWvanLeeuwen]

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

Spoiler