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
11 - Bolide
11 - Bolide

Here's my solution with iterative macros to solve both the easy and the net scrooginess =< 13

Spoiler
WorkflowWorkflowIterative macro for any pairIterative macro for any pairIterative macro to cap net Scroogieness to 13Iterative macro to cap net Scroogieness to 13
Highlighted
11 - Bolide
11 - Bolide

[Duplicate post]

Highlighted
Alteryx Certified Partner

Took a simple route. Not sure if I got the right answer, But, am confident that I took logical and straightforward steps!

 

*// EDIT: I completed this challenge for all possible combinations!!!! 

 

 

Spoiler
Capture7.PNG

 

Highlighted
Alteryx Partner

Here my first 'weekly challenge' solution contribution, not short as in 5 tools (I have 3 extras for sorting and to calculate the net), but hey, this is my first contribution and it is exactly sorted the way it was sorted in the output request and works for any given number of names/records (not only 50). Wish all a happy 'advents' time. 

Highlighted
8 - Asteroid

My Solution: 

 

Spoiler
144.PNG
Highlighted
Alteryx Certified Partner

Fun one 🙂

Highlighted
Alteryx
Alteryx

I went down a route that I wasn't 100% sure would work due to the logic being very simple.....

 

Spoiler
Basically matched the highest with the lowest, and hoped the middle would sort itself out, thankfully it did.

Workflow.png
Highlighted
8 - Asteroid

Here is my solution. Nice and simple and works for scroogieness as well.

 

Spoiler
144.PNG
Highlighted
8 - Asteroid

Here is my solution... same results!

Highlighted
17 - Castor
17 - Castor

I had to throw this one in since nowhere did @JoeM say that the basic pairings had to be random!  3 tools!

 

Spoiler
fixed solution.png

 

A more robust solution is on the way

 

Dan