Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

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

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

Highlighted
8 - Asteroid

A beginner's solution using Multi-Field Binning. 

Highlighted
6 - 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
12 - Quasar
12 - Quasar

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!