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
7 - Meteor

My solution

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

 

Highlighted
8 - Asteroid

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

Highlighted
6 - Meteoroid

that was a quick one

Highlighted
14 - Magnetar
14 - Magnetar

Ho ho ho! Secret Santa solution attached 🙂

 

Spoiler
Iterative macro to select one pairing each iteration, and then remove that Secret Santa & recipient from the iterative input for the next round.Iterative 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

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

Highlighted
8 - Asteroid
Spoiler
AWC_144.JPG
Highlighted
Alteryx Partner
 
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Spoiler
Challenge 144 - Capture.PNGThe Pythonic WayThe Pythonic Way