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

DaisukeTsuchiya
14 - Magnetar

Interesting challenge!

 

Spoiler
キャプチャ.JPG
jasperlch
12 - Quasar
Spoiler
Capture.JPGCapture2.JPG
DeanWest
9 - Comet

Late to the party today, but this was a fun challenge to start the week!

 

Spoiler
Create the Round Robin Pairs (including all round variations)
challenge_247_solution_DeanWest_snippet-1.png
Spoiler
Batch Macro joins the RecordID's made in the Round Robin Table to get names from the original data set.
challenge_247_solution_DeanWest_snippet-2.png
T_Willins
14 - Magnetar
14 - Magnetar

Another fun challenge.  To solve the advanced challenge I used an Iterative Macro to create all the pairings.  Bonus:  Not only is it dynamic to the number of participants, but also will manage odd numbers of participants by adding a "Bye Week" for one participant each week.

 

Spoiler
Iterative MacroIterative Macro

 

WorkflowWorkflow

 

RolandSchubert
16 - Nebula
16 - Nebula

Great challenge! Used an iterative macro based on circle method.

 

Spoiler
Workflow:
247-1.png

Macro:
247-2.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I have reached no macro route.

Spoiler
AkimasaKajitani_0-1608639130551.png

 

Qiu
21 - Polaris
21 - Polaris

@PhilipMannering Congratulations.

Followed the round-robin tournament with a batch macro

Spoiler
en-247-01.PNGen-247-02.PNG
Greg_Murray
12 - Quasar

@PhilipManneringI thought this looked familiar. 

 

Here is my solve, much improved from what I posted a few weeks ago.

Spoiler
workflow
Greg_Murray_0-1608647205119.png

iterative macro

Greg_Murray_1-1608647226103.png

 

Sashikumar
8 - Asteroid

Good one.

Spoiler
ch247.PNG
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1608696633976.png