Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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 Alumni (Retired)

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
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.PNG
randreag
11 - Bolide

here is the solution 

phottovy
13 - Pulsar
13 - Pulsar

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
11 - Bolide

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

Spoiler
270.png