ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

Arran_S
8 - Asteroid

Attached

mceleavey
17 - Castor
17 - Castor

Catching up with some old challenges.

 

Spoiler
Workflow.jpgWith this one I sorted the data by Scroogieness, then split the stream taking the top and bottom 25 records, I then smooshed them back together by joining on record position, created the calculation and sorting by net-scroogieness descending.
Simple.

Nice.



Bulien

vinspad
8 - Asteroid

I have two solutions for this one.

 

The first is a quick solution that matches the "solution browse," however there are only 25 records. Either only have of the people will have a Secret Santa, or each person in a pair will receive a gift from the same person they gave one to which ... isn't very secretive.

 

So my second solution is a bit longer and required the random and unique tools to ensure we didn't have duplicates *and* that we didn't have someone giving two presents nor receiving two presents.

 

A bit tougher, but we got there eventually.

Volha
8 - Asteroid
Spoiler
Volha_0-1758121019806.png

 

mattnason1
9 - Comet

Quick and easy one.  BAH HUMBUG!

SamHD
8 - Asteroid

Fairly happy with what I came up with!

Spoiler
SamHD_0-1761212194574.png

 

erica_sch
8 - Asteroid

Solved!