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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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 #144: Secret Santa Assignments (BAH HUMBUG!)

Bonero
6 - Meteoroid

my solution

Emil_Kos
16 - Nebula

Hi,

 

It was fun to see how other people approached this issue. 

 

Spoiler
Challenge_144_Emil_Kos.PNG
deviseetharaman
11 - Bolide
Spoiler
 
meetpuru
8 - Asteroid

Soln

phottovy
12 - Quasar

I may have to try this one as a macro but this solution will do for now.

StellaBon
9 - Comet

I figured out the pairings but seem to have too many results for Net Scrooginess, hmm. 

mulvihi11
8 - Asteroid

No humbugs here! 

Spoiler
mulvihi11_0-1595269862630.png

 

treepruner
9 - Comet

ok, I'm not sure why the solution is only showing Net_Scrooginess of 11, 12 and 13 when 1-10 are also less than 13...

 

I know I'm not letting people match themselves, but I think I have 2x as many records as I need because of the  a = b is the same as b = a  issue.

 

Wish there was an official solution!

Samanthaj_hughes
11 - Bolide
11 - Bolide

There is definitely a macro solution to this too. Went for the easy road. 

#Alteryxrocks
ehughes
9 - Comet

Not sure this method can be expanded beyond this example, but it works 😅

Spoiler
Img 144.PNG