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 #247: Pairing Partners

8 - Asteroid

Alteryx

Here is my solution. No macro was needed.

Spoiler

16 - Nebula

So I got doing down the wrong path, but refused to admit it was total junk. So my solution involves a few hardcodes and isn't dynamic (and is indeed junk).

Spoiler

EDIT: I refused to give up. I finally found a way to solve it going down the wrong path.

Spoiler
If you set it up JUST RIGHT, I was able to use the optimization tool to get the pairs all lined up. I really struggle with the optimization tool as there are too many ways to do it wrong.

Alteryx

No need to reinvent the wheel, so I implemented the circle algorithm for scheduling round robin tournaments (see Wikipedia).

Should work on any even number of participants. For uneven numbers, a dummy can be added to the input to make it even.

Comparing the results I get the same pairings, just in a different weekly order, success!

Spoiler
11 - Bolide

Here the solution

10 - Fireball

Definitely started with overcomplicating things, but I think I managed to find my way out!

Spoiler
main workflow

iterative macro inside

6 - Meteoroid

No macros necessary 🙂

15 - Aurora

Challenge Completed

Spoiler

13 - Pulsar

Used iterative macro to solve this challenge.  Need to update maximum number of iteration manually when number of records changes. So that iteration stops once each people played each other people.  Example, iteration would be 5 for 6 people, it would be 7 for 8 people. it is kind of manual. I could not make it dynamic. However, made the pairing/partnering fully dynamic.

Spoiler

11 - Bolide

Algorithm is not easy to set up !

Spoiler