We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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

Bennu
8 - Asteroid

No I'm not proud of it but it works HAHAHA.

Spoiler
WC_270.jpg
BS_THE_ANALYST
15 - Aurora
15 - Aurora

Dynamic solution with a macro, it's limited by the max number of iterations - in my case 100. Whenever it comes to permutations and combinations I do feel like Python is our friend. 

Spoiler
Time Taken: 34:02
Screenshot 2025-05-26 175245.pngScreenshot 2025-05-26 175252.png

  



 

All the best,
BS

LinkedIN

Bulien
Pilsner
13 - Pulsar

Second time round tackling this problem. Tried to make it fully dynamic so it will get all combos for any number of horses (up to 100 due to max iteration number in macro). Would highly recommend it if anyone else wants that extra layer of difficulty!

Spoiler
Workflow:

  

270 (second try).png


Macro:

270 (macro second try).png


Time Taken: 00:20:30

  

BhumikaGoel
7 - Meteor

Easy One!!!

Spoiler
Screenshot 2025-05-29 102316.png
TheOC
16 - Nebula
16 - Nebula

Pretty crafty one, interested to see how others have solved this....

 

Spoiler
I originally started with a generate rows / cartesian join, but figured it was too messy. This way seems to work although it's not very dynamic.
Screenshot 2025-06-07 183537.png
Cheers,
TheOC
Connect with me:
LinkedIn Bulien
aiahwieder
9 - Comet

It would appear I solved this over a year ago and never posted my solution . . . ? Past Aiah must have been distracted.

jli924
8 - Asteroid

My solution