Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #247: Pairing Partners

robert-headington
8 - Asteroid
Spoiler
RH0258_0-1611522339857.png

 

Decided not to look at the wikipedia page as an idea hit me straight away so the logic may be different but it works. Made a batch macro to do this but I could have easily made it an iterative one.

 

This solution will work for any even number of people. I enjoyed this.

Tony_Castillo
9 - Comet

Matches criteria where no pairing is repeated

Spoiler
TC_bot_0-1611777220658.png

 

rmassambane
10 - Fireball

...

OllieClarke
15 - Aurora
15 - Aurora

Implemented the Wikipedia solution in Alteryx, but it will work for even or odd numbers of people 🙂

 

Spoiler
Used the formula from wiki as the iterative check:
([Max]-1) != ([Engine.IterationNumber]+1)​

MacroMacroWorkflowWorkflow
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

This was a super cool challenge. Learning the way how to use the Circle method was really fun!

 

Emil_Kos_0-1612727919511.png

 

kelly_gilbert
13 - Pulsar

Just for fun, an implementation of the Schurig table method, which will work for odd and even counts.

 

Spoiler
kelly_gilbert_0-1613068420850.png

 

 

apathetichell
19 - Altair

Here's my solution!

PhilipMannering
16 - Nebula
16 - Nebula

Finally posted the answer to the question I set. See my non-iterative macro  solution attached,

 

Spoiler
workflowworkflow
rcarog
8 - Asteroid

Solution attached.

danicahui
8 - Asteroid

Was a bit challenging to get my head around at first but understanding the rules for the wiki helped!

Spoiler
Challenge 247 2021-03-04.jpg