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.

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

Meteor

My solution

Asteroid

So I originally misunderstood and thought we were supposed to come up with 50 distinct combos that listed gift giver -> receiver, so I included that too /shrugEmoji

 

 

Spoiler
Screen Shot 2018-12-18 at 9.45.00 AM.png
Macro detour:
Spoiler
Screen Shot 2018-12-18 at 9.45.28 AM.png

 

Asteroid

I hope I'm not too late for Secret Santa. Oh dear, I think I am! :p

Meteoroid

that was a quick one

Ho ho ho! Secret Santa solution attached :)

 

Spoiler
SecretSantaMacro.JPGIterative macro to select one pairing each iteration, and then remove that Secret Santa & recipient from the iterative input for the next round.WeeklyChallenge144.JPG

Merry Christmas!

NJ

Asteroid

Here's my solution along with one I made for my family exchange. The criteria for the family exchange is not to pick yourself, your spouse, and that it's a single loop (e.g. given people A, B, C, D, and E, you couldn't have the following assignments: 1) A has B has C has A and 2) D has E and E has D). I might update it so you also don't have the same person as you did the prior year. 

Spoiler
AWC_144.JPG
 
Asteroid

Challenge Completed

Alteryx Certified Partner

My solution below. Had a go at doing it in the python tool too.

 

Spoiler
Challenge 144 - Capture.PNGChallenge 145 - Capture Python.PNGThe Pythonic Way