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

Alteryx

A solution to last week's challenge can be found hereSource: https://en.wikipedia.org/wiki/Round-robin_tournament

This week's challenge was submitted by @PhilipMannering  - Thanks for your contribution!

This problem was inspired by a question on the Community forums:

With remote working the norm, it's difficult to get some one-on-one time with other people in your team. Given the list of names, generate pairings of people for each week. Everyone should have a partner. And no pairing should be repeated.

15 - Aurora

Challenge 247 is done, closing down on that 250 badge now!

Workflow:

Spoiler

Batch Macro:

Spoiler

11 - Bolide

I can only think in (nested) iterative macros this week...

Spoiler

outer iterative - spits weekly combinations The inner iterative generates each week's combination. The outer iterative continues to feed data to the inner as long as there are meetings that have not taken place yet

12 - Quasar

Mod function and tile tool to the rescue! Great challenge, @PhilipMannering !

Spoiler

15 - Aurora
Spoiler
Dynamic solution with iterative macro

12 - Quasar

I still want to tackle odd number of competitors but I believe I replicated the "Circle Method" in my macro.

Spoiler

8 - Asteroid

Fun one! Started doing iterative but wished to avoid iterative within iterative so just went to wikipedia to be told what to do 😄
Will only work for an even number of people.

Spoiler

9 - Comet
Spoiler
Challenge #247 in the can
Alteryx

This was a fun one. Very interested in seeing other solutions. Thanks to @Greg_Murray for showing how to capture all intermediate results from an iterative macro in last week's challenge.

Spoiler
13 - Pulsar

I found multiple solutions that worked, but don't match the answer provided.  But I validated it manually and my answer meets the criteria....everyone meets and no pairing repeated....