community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #144: Secret Santa Assignments (BAH HUMBUG!)

Asteroid

Looking forward to some Santalytics!  I might need to do something in Santableau too...

Alteryx Certified Partner
 
Alteryx
Alteryx

First time posting - Happy Christmas!

Meteor

Got the answer as shown in the output, but this was assuming that everyone was giving to and receiving from the same person. Wouldn't a true secret santa have 50 random pairings?

Meteor

A beginner's solution using Multi-Field Binning. 

Meteoroid

My Solution:

Spoiler
144.JPG
Alteryx
Alteryx

Non dynamic first attempt, with a more dynamic solution included too

Alteryx
Alteryx

Festive fun!

Alteryx
Alteryx
 
Bolide
Bolide

I came up with several solutions that would have worked (in theory), but would have filled up my computer.  Actually solved with some simple logic and a standard macro.

 

Love the references to Mickey's Christmas Carol in your intro!