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.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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

8 - Asteroid

#144 Solution: Tools used Sort, RecordID, Summarize, Append, Filter, Formula, Select.

8 - Asteroid

Thank you for the challenge!
I was able to complete it.

Regards
K

8 - Asteroid
Spoiler

I leveraged Kat's solution with iterative macro, as I am exploring the world of macros.  Thank you @kat

One thing though:  I tried to have Total Scroogieness match  the output solution provided using the max scrooginess scores, but the iterative macro only giving random matches, though I tried to sort,  but it is not quite matching the solution.  @kat, appreciate your help, if this is possible to accomplish in iterative macro, I tried to tweak yours, but still could not get it to match the descending sort order for Total Scroogieness provided.  Appreciate someone's help on this.

8 - Asteroid

My solution. Did it similar other simple methods

Spoiler

Alteryx

Done!

Spoiler

Benoit Conley

Sales Engineer
Alteryx, Inc.

11 - Bolide

Finally got there with an iterative macro I'm happy with. It's actually quite balanced aswell in terms of choosing the secret santa partners

Spoiler

6 - Meteoroid

My solution. Same results with the sample output.

7 - Meteor

My solution to the problem using core tools only -

8 - Asteroid
Spoiler

8 - Asteroid

solved