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

JennyMartin
9 - Comet
Spoiler
AWC247M.PNGAWC247.PNG

I spent a long time going on completely irrelevant tangents before finally giving in and looking at the hint! The only thing I can't work out is why there is so much duplication in the output for my Macro, but that's easily resolved with a summarise tool! Video solution here: https://www.youtube.com/watch?v=0-ZbWH9dZio&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=50

Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-247-Pairing-Partners/td-p/683230
atcodedog05
22 - Nova
22 - Nova

This was a real brain teaser.

 

Thanks for this challenge @PhilipMannering 

 

Spoiler
atcodedog05_1-1608798325480.png

its not the exact answers but it does create unique pairs.

 

PS: let me see how was the solution workflow built to get those answers.

 

Cheers and Happy Analyzing 😀

Merry Christmas🎅

AngelosPachis
16 - Nebula

My solution for challenge #247

 

AngelosPachis_0-1608915256584.png

 

PraphulSamavedam
8 - Asteroid

Done with this as well.

All possible pairs have been created, however the week number might be different. 

 

RichoBsJ
11 - Bolide

Hi! Intermediate? This was a tough one haha! 😉

 

Spoiler
challenge247.png
Spalders
8 - Asteroid

Simple solution using the Circle method described in Wikipedia - needs a bit more work to make it work for any even number of people.

cpapaioannou
7 - Meteor

No macros. 'Advanced' dynamic solution. Used 8 tools.

Spoiler
cpapaioannou_0-1609193905715.png

 

Quite interested in possibly shorter solutions.

 

Great challenge.

LHolmes
9 - Comet

Found myself heading down the macro-rabbit-hole with this one and then pulled up before flying into the mountain. Ultimately solved the challenge and then rethought my approach creating a generic answer that will work for both even and odd counts of people (the odd scenario removing the bye each week). All in all pretty slick!

 

Spoiler
247 - Solution.PNG
kmedici
8 - Asteroid
Spoiler
 
marioyuwono
8 - Asteroid

247.png