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
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 144 is done!

 

Spoiler
challenge 144 JMS solution.PNG
Highlighted
7 - Meteor

Done!

Spoiler
#144.PNG

Highlighted
8 - Asteroid
Spoiler
 
Highlighted
7 - Meteor
 
Highlighted
7 - Meteor
 
Highlighted
7 - Meteor

Spoiler

Highlighted
Alteryx Partner

Pretty straight-forward....

 

Spoiler
Getting better at seeing when to use RecordID

Process:
- Sort by Scroogieness
- Add RecordID
- Split into Top and Bottom 25 by Scroogieness
- Resort one of the threads (so we can match most Scroogie with least Scroogie
  -- New RecordID will allow the join in the right order
- Join two threads so that #1 Scroogie effectively matched to #50 Scroogie
- Calc combined score
- Clean-up

MySolution.PNG
Highlighted
Alteryx Certified Partner

Quick answer

Spoiler
challenge 144.png
Highlighted
Alteryx Certified Partner

Solution attached.

Highlighted
8 - Asteroid

Challenge done - similar to most others!

 

Spoiler
Week144.PNG