The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
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 #469: Many-to-Many Like it Hot – Part 2

rmassambane
11 - Bolide

469

Dhrish
8 - Asteroid

solution

aiahwieder
9 - Comet

TabascoHotSauceGIF.gif

jrlindem
13 - Pulsar

Threw a Union Tool in my solution.  I realize the way this data computes it wouldn't be necessary in order to match the solution (since any records that don't have an adjoining flavor/viscosity won't average out to a Score of 5); but if the data changed, it could...  And the challenge asked for any Sauces that met that rating, not just those with flavor/viscosity data.

 

Anyway, another fun one.

 

Spoiler
jrlindem_0-1754602702997.png

 

dstevens92
6 - Meteoroid

My Solution

Sarah_Temple
5 - Atom

My Solution

ARussell34
8 - Asteroid

Found the top hot sauces, will have to give one or two a try!

Spoiler
AR_469.png
BSilverblatt
8 - Asteroid

This is my solution:

Shivraj96
7 - Meteor

Here is the solution file with my approach, kindly review it and let me know where the possibility of improvement. Thanks in advance. 

estherb47
15 - Aurora
15 - Aurora
Spoiler
estherb47_0-1761076609130.png

 

for some fun we had a few years ago: https://www.youtube.com/watch?v=EeJTCOhmJuc