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.

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

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
21 - Polaris

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
15 - Aurora

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
10 - Fireball

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