community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

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

Alteryx Partner

Simple first pass solution with minimal tools. Only saw one other use this same method. It works for this data set, but might not if there is a different balance of scroogieness. Might be time to learn macros.

 

Spoiler
image.png

Catching up!!

Asteroid

Hi @JoeM ,

 

Here is my solution. 

 

Best Regards,

Samuel

Asteroid

Finally getting round to submitting my answer even though I suggested it XD

 

 

Spoiler

 

I chose to have two workflows, the first which would allow people to opt in if they wanted to participate (and also put down a Christmas wish) these were saved to a yxdb and a second to be ran to allocate out across those opted in. Worked really well in the office :)

 

I know I'm way late to the game, and therefore the Secret Santa theme isn't as timely, but this looked like fun, so I decided to go ahead and tackle it.  I ended up with a different set of matches than the included solution (1 the same, but the other 25 different), but I believe my solution meets the criteria.  However, I'm not 100% sure my solution is foolproof, if some higher scroogieness scores made a solution harder to come by.

Highlighted
Alteryx Certified Partner

My solution :)

Spoiler
challenge_144.PNG
Meteoroid

Hi,

 

My first attempt at a challenge ! Enjoyed it !

Bolide

Ah the scrooginess! I may be somewhat high on the scrooge scale as I always tell my wife Christmas music is reserved for Christmas day

Spoiler
Challenge 144.PNG
Alteryx
Alteryx

Unless I missed something, this was probably the simplest of the beginner-rated challenges that I've seen. My solution is similar to Patrick Digan's.

Spoiler
Sort the list by Scrooginess. Use the sample tool to split the first half and last half into separate data sets, then reverse the sort on one half and do a join on record positions. Sum the two scroogieness columns. You'll have unique pairings and the lowest set of pair values
Asteroid

not a very flexible solution but it does the job