Fixture List Generator

I want to create a Fixture List for a tennis tournament I'm soon playing. The number of players is 18 and the number of matches each player would play is 17 (153 matches in total)

The issue I'm facing can be viewed on the Iterate output of the "All Rounds" macro. I can allocate all but 18 remaining matches on all of the 17 rounds.

I've attached the Alteryx Package (which contains the main workflow and all its macros)

Transformation

Accepted answers

Hello @rcarog ,

Here you go

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

All comments

Can you describe what you are trying to achieve? Some sample data of your original input as well as the final output would be helpful as well!

Hello @rcarog ,

Here you go

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Brilliant workaround! I did not expect this. Thanks for the help!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703