Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎12-04-2018 01:37 PM

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

challenge_144_start_file.yxmd
Reply
CharlieS
17 - Castor
17 - Castor
‎12-04-2018 02:35 PM
 
Challenge_0144-CharlieS_Solution.yxmd
Reply
EmilyCR
Alteryx Alumni (Retired)
‎12-04-2018 06:07 PM

First time posting - Happy Christmas!

challenge_144_solution_EC.yxmd
Reply
KyleCollins
7 - Meteor
‎12-04-2018 09:07 PM

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?

challenge_144_KyleCollins.yxmd
Reply
ultrarunner
8 - Asteroid
‎12-04-2018 09:26 PM

A beginner's solution using Multi-Field Binning. 

challenge_144_ultrarunner.yxmd
Reply
Hoang7
6 - Meteoroid
‎12-05-2018 01:04 AM

My Solution:

Spoiler
144.JPG
challenge_144_santa.yxmd
Reply
NickC
Alteryx Alumni (Retired)
‎12-05-2018 01:27 AM

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

challenge_144_completed_file.yxmd
Reply
JamesMA
Alteryx Alumni (Retired)
‎12-05-2018 01:28 AM

Festive fun!

James Marks Week 144.yxmd
Reply
RandeepB
Alteryx
Alteryx
‎12-05-2018 01:36 AM
 
RB_WeeklyChallenge144.yxmd
Reply
ggruccio
ACE Emeritus
ACE Emeritus
‎12-05-2018 07:49 AM

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!

challenge_144_gg_finish.yxzp
Reply
Live Weekly Challenge