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.

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 #298: Christmas Treasure Box

AYXAcademy
Alteryx
Alteryx
A solution to last week’s challenge can be found here
  
Weekly Challenge Image 298 (1).pngFor this challenge, you will be hosting the perfect Christmas night! You've invited friends over to eat cookies, listen to music, and watch a movie!
 
This is a two-part challenge: First you must choose each item (type of cookie, music and movie) based on a specific criterias that are in the container boxes below (you have opinionated friends), then you must use your 3 selections to find the key to the treasure box. The treasure box holds a special gift from your Weekly Challenge team!
 
(Hint: Label your final selection column as "Answer")
 
Cookie Criteria: Choose the cookie recipe that makes the most cookies!
1. You have 1000 grams of butter and 1000 g of sugar. 
2. The cookies recipes require the ingredients as listed. 
3. You are not limited by any of the other ingredients. 
 
Music Criteria: Choose a Christmas playlist for your guests while you eat cookies!
1. Assume each song is 3 minutes and that your total music playtime will be 45 minutes - this determines how many songs you have on the list!
2. Every song must be a -9 or lower in loudness (ex. -15 would be a very quiet song)
3. Eric wants all the minor songs and Matthew wants songs in F major.
4.Thalita loves Dean Martin!
5. Put the songs in order of loudness, so the music builds as a transition to the movie.
The title of the last song is your "answer"! 
 
Movie Criteria: Choose a crowd-pleaser movie
1. You only want a movie that was released in the theater
2. Nicole doesn't want to watch an animated movie. 
3. Ryan is feeling nostalgic and wants to watch something from the 80's or 90's.
4. It must be the top rated movie of the year it debuted.
5. The movie with the longest run time in the Comedy genre is your "answer"!
 
After all that hard work to create the Best Christmas Evening Ever, use your three answers to find the key to the treasure box!
1. Use the provided lookup table to "find and replace" your answers to produce three sets of scrambled letters and numbers (hint: label column as "Answer"). 
2. Concatenate the key and add to the provided formula tool.
3. Once you run the key through the formula tool, you may open the treasure box and put the link in the tool configuration!
 
Resources:
Watermark
11 - Bolide

Do we assume 'whole' recipes?  Or can you make partials?

AYXAcademy
Alteryx
Alteryx

@Watermark Yes, the entire recipe.

AkimasaKajitani
15 - Aurora
15 - Aurora

My solution!

 

Spoiler
AkimasaKajitani_0-1639407270863.png

 

Watermark
11 - Bolide
Spoiler
MT_Solution 298.png

Christmas Result.png

 

Merry Christmas and Happy Holidays to all

JereJussila
8 - Asteroid
Spoiler
JereJussila_0-1639409565033.png

 

 

 

AngelosPachis
16 - Nebula

Thank you Alteryx Weekly Challenge Team for another great challenge and for all your wishes!

 

Alteryx weekly challenges have helped me massively to improve my Alteryx skills and are an integral part of the community for me. I hope they continue for years to come!

 

 

Spoiler
AngelosPachis_0-1639409334629.png

 

Merry Xmas everyone 🎅🎄

 

binuacs
17 - Castor
Spoiler
binuacs_0-1639414812574.png

 

dYoast
9 - Comet
Spoiler
dYoast_0-1639415110274.png

 

Enjoy the season.

alexnajm
10 - Fireball

Happy Holidays everyone!

Spoiler
challenge_298_start_file_Alex Abi-Najm.PNG