Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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

Highlighted
Asteroid

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
 
Highlighted
Alteryx
Alteryx

First time posting - Happy Christmas!

Highlighted
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?

Asteroid

A beginner's solution using Multi-Field Binning. 

Highlighted
Meteoroid

My Solution:

Spoiler
144.JPG
Highlighted
Alteryx
Alteryx

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

Highlighted
Alteryx
Alteryx

Festive fun!

Highlighted
Alteryx
Alteryx
 
Highlighted
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!