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

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