Challenge #247: Pairing Partners

[SeanAdams]

Found a bit of a cheeky way to do this without too many tools 🙂

Nice one @PhilipMannering 

Spoiler

Used an append tool to create a cartesian join (join all names to all other names)
Then filter out a self-join (Jim meeting with Jim)
Then a very simple iterative macro to break this into weeks using a unique tool.

Main flow



Macro

[JoshuaGostick]

My solution

Spoiler

Spoiler

[BeginnerMindset]

Great challenge.  I went with an iterative macro to make generic solution and tested on a longer list.  Works a treat.

Spoiler

Spoiler

[NicoleJohnson]

This might be one of my favorites in a while - an Iterative Macro AND I got to use my favorite Make Columns tool???? That's a tournament winner for sure!!

Spoiler

Super fun one - I know some people have a love-hate relationship with iterative macros, but I kid you not, I love them more than any other macro. I'm glad we had the hint to take a look at the Wikipedia page for Round Robin tournaments - I was able to recreate the bracket-shifting that was shown in the example, and it feels very flexibile, for any value of even-numbered players. 

To create this algorithm in Alteryx iterative macro form, it really came down to a re-ordering technique that would not only "wrap" the players around for matchups (left to right on the top row, right to left on the bottom) but would also replace player two with the last player in the lineup with every round. Key players in this matchup were RecordID, Sample tool, and MY FAVORITE DARK HORSE TOOL EVER, the glorious Make Columns tool. I love this little guy... it's not often I find uses for him, but when I do, THEY ARE MAGICAL. 

The iterative input/output is just the reordered list, using the Round Robin algorithm/example, and then it stop the iterations once it reaches the appropriate number of rounds. 

Wrapped it up in the main workflow, gave it a pretty bird icon, and smiled to myself at this victory. 🙂 NOTE: I opted to use PlayerID's for my macro and then match the ID's to names at the end, since it was easier for me to see the order and align it with the Wikipedia example when they were numbers, but could certainly have been done with actual names too.

Cheers!!

NJ

[Maskell_Rascal]

This one was tough, since I'm still new to iterative macros. Great challenge though!

Spoiler

Workflow:

Iterative Macro:

[papalow]

A good challenge....but not my best execution.  

[DataHabanero]

Ready!

[Lili1]

Here is my solution!

Spoiler

-

[cAral]

Thought this was a unique solution that does not use macros or the tile tool. It also handles use cases for odd number of participants. 

Spoiler

[Amin]

Spoiler

No macros and  following my personal policy of no "hardcoding".