Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
7 - Meteor

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