community
cancel
Showing results for 
Search instead for 
Did you mean: 

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!)

Asteroid

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

Alteryx Certified Partner
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?

Asteroid

A beginner's solution using Multi-Field Binning. 

Meteoroid

My Solution:

Spoiler
144.JPG
Highlighted
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!