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.
alteryx Community

# 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

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

8 - Asteroid
Spoiler
Alteryx

Permutations in Alteryx!

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

Spoiler
11 - Bolide

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

Spoiler

8 - Asteroid

!!  + Credit

1) Append

2) Generate Rows

Third method would leverage a macro?

7 - Meteor

Spoiler

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

12 - Quasar

My solution:

Spoiler
11 - Bolide

here is the solution

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:

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

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

Spoiler