We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

sann0638
8 - Asteroid

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

CharlieS
17 - Castor
17 - Castor
 
EmilyCR
Alteryx Alumni (Retired)

First time posting - Happy Christmas!

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

ultrarunner
8 - Asteroid

A beginner's solution using Multi-Field Binning. 

Hoang7
6 - Meteoroid

My Solution:

Spoiler
144.JPG
NickC
Alteryx Alumni (Retired)

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

JamesMA
Alteryx Alumni (Retired)

Festive fun!

RandeepB
Alteryx
Alteryx
 
ggruccio
ACE Emeritus
ACE Emeritus

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!