Hello Community members, A solution to last week’s challenge can be found here. This is Part 2 of the challenge created by James Gust. Thank you again, James, for this spicy challenge! In Part 1, you successfully determined the flavor and viscosity labels for each sauce. Now it’s time to take things to the next level and uncover which sauces are the highest-rated! For this challenge, you are provided with two datasets: * Hot Sauce Data.xlsx: Contains sauce details, manufacturer, location, and overall ratings, where 5 is the highest and 1 is the lowest. * Viscosity and Flavor Data Text Input: Lists viscosity and flavor descriptions per Sauce ID. Your challenge is to create a workflow that displays the highest-rated sauces, meaning that any sauce with an Overall Rating of 5 should be included in the final output. Also include in your output file: * Manufacturer name and location * Sauce name * Heat sources * Average overall rating * Percentage of tasters that "loved" the sauce * Average spiciness * Flavor notes and viscosity Need a refresher? Review the following lessons in Academy to gear up: * Numeric Functions * Joining Data Good luck! The Academy Team Challenge469_start_file.yxzp Challenge469_solution_file.yxzp

Hi @PSWJPM, Thanks for reaching out to us. We all trip up while building workflows. 🙂 You will notice that the Hot sauce data.xlsx dataset has multiple entries for the same hot sauce, so filtering the raw data for Overall Rating = 5 will return all individual 5-star reviews, not just the final list of sauces. Hence, while calculating the rating for each hot sauce, you will need to take an average of the ratings it received from individual reviews. To calculate this average, please add a Summarize tool and add an average for the overall rating. (You will need to do a bunch of group bys and averages for other data as well) Once you have the average Overall Rating for each hot sauce, please add a filter to keep only those with an average Overall Rating of 5. You will get the 5 hot sauces that meet the 5-star criteria. Hope this helps. Reach out to us if you have any other questions. Take care.

Here's my solution Challenge469_solved.yxmd

Challenge #469: Many-to-Many Like it Hot – Part 2

AYXAcademy

Weekly Challenge LMS Banner.png

Hello Community members,

A solution to last week’s challenge can be found here.

This is Part 2 of the challenge created by James Gust. Thank you again, James, for this spicy challenge!

In Part 1, you successfully determined the flavor and viscosity labels for each sauce. Now it’s time to take things to the next level and uncover which sauces are the highest-rated!

For this challenge, you are provided with two datasets:

Hot Sauce Data.xlsx: Contains sauce details, manufacturer, location, and overall ratings, where 5 is the highest and 1 is the lowest.
Viscosity and Flavor Data Text Input: Lists viscosity and flavor descriptions per Sauce ID.

Your challenge is to create a workflow that displays the highest-rated sauces, meaning that any sauce with an Overall Rating of 5 should be included in the final output.

Also include in your output file:

Manufacturer name and location
Sauce name
Heat sources
Average overall rating
Percentage of tasters that "loved" the sauce
Average spiciness
Flavor notes and viscosity

Need a refresher? Review the following lessons in Academy to gear up:

Good luck!

The Academy Team

Challenge469_start_file.yxzp

Challenge469_solution_file.yxzp

Join

Core

Transform

Basic

Accepted answers

All comments

AYXAcademy

This is the last week of our contest! Submit your Weekly Challenge idea for a chance to win prizes! Use the link below to submit until March 31st.

Submit Your Challenge

Read more about the contest here:

https://community.alteryx.com/t5/Weekly-Challenges/Calling-All-Community-Members-Submit-Your-Ideas-for-Our-2025/td-p/1375973

Pilsner

Fun challenge:

Spoiler

469 (Hot Sauce Part 2).yxzp

martinson

Saucy Challenge

Challenge469_start_file.yxmd

TheOC

Quite a fun one!

Spoiler

I have to be honest, I did get mixed up between the numerous ID's in the hot sauce data. Always worth double checking you're using the correct variables in a join!

Challenge469_TheOC.yxmd

3I_ATLAS

Mildly confusing because the data already has an 'Overall Rating' field and the instructions say 'Any sauces with an overall rating of 5' when the intended was Average Overall Rating.

Or maybe i haven't had my coffee yet...

You will also be reminded you must never use Double data type fields in Joins. 😗

Spoiler

challenge_469_Solution.yxzp

DylanBell

This one had my tongue tingling.

Challenge469_start_file.yxmd

Kenda

Spoiler

Challenge469_start_file.yxmd

mmontgomery

C469

Spoiler

c469.yxzp

RolandSchubert

Spoiler

challenge469_solution_rsc.yxzp

Milanz

my solution ;-)

Spoiler

Challenge469_ML.yxmd

Bobbyt23

Good follow up challenge to the first one.

Spoiler

Weekly Challenge 469 24-03-25.yxzp

JBevan89

My Solution attached.

Spoiler

Feeling Hot, Hot, Hot!!

Spoiler!

Challenge469_CK.yxmd

alexnajm

Done!

Spoiler

Challenge469_start_file_Alex Abi-Najm.yxzp

balajilolla2

Spoiler

Solution Attached

Screenshot 2025-03-24 095434.png

Challenge469_start_file.yxmd

ggruccio

Fairly quick and easy!

Spoiler

Challenge469_gg_finish.yxzp

Hub119

Solution attached.

Spoiler

Challenge469_CH Solved.yxzp

TurboToad

My take.

Spoiler

TT_Challenge469_solution_file.yxzp

braveraj

Spoiler

Challenge468_saucey_pt2.yxmd

tkemp

In the absence of a Percentage data type, is there a convention that says to show percentages as Int32 instead of decimal representation housed as Double?

Background: Instead of the decimal representation of 0.75 stored as Double, Percent Loved is multiplied by 100 and converted to Int32 to match 75 as shown in the Output File. Int32 (as stored in output file) at 4 Bytes saves 4 Bytes relative to the Double data type. An Int16, or even a byte (assuming all values will be positive), could store 75 with 2 bytes or even 1. As stored, 75 would be equivalent to 7500% and would require a division step if used in future calculations. I don't know what is most efficient, but I was just curious after changing the data types in my workflow to match the output. Maybe the data types in the output were arbitrary.

Challenge469_TK.yxmd

olga_strubbe

Thank you, James, for the fun challenge! It was quite interesting learning about various hot sauces.

Spoiler

Challenge 469 part II_OS.yxmd

MadyeIBT

Spicy fun

Challenge469_completed_file_MIBT.yxmd

wrones104

I feel a lot better about this one than my last one ha!

Spoiler

Challenge469_start_file_WJ.yxmd

myastarling

Here's my solution!
Now I have a whole bunch of new hot sauces to try out! 😁

Challenge469_myastarling.yxmd

binu_acs

Spoiler

Challenge469_solution_BV.yxmd

AaronSmatta

Fun challenge, but not so much a hot sauce guy.

Challenge469_start_fileAT.yxmd

Yoshiro_Fujimori

My solution.

Spoiler

Workflow

Formula Tool
[Percent Loved] = [Sum_Loved?] / [Count] * 100
[Spiciness] = Round([Spiciness], 0.01)

Challenge469_YFujimori.yxzp

alineruizcampos

Spoiler

Challenge469_Aline.yxmd

wbasuki

My solution

Spoiler

Challenge469_start_file_WB.yxmd

sjpost

The sample output file doesn't have sauce ID, my output does, but I think it's a crucial variable, so I'm keeping it there.

Challenge469_start_file my solution.yxmd

PSWJPM

Hi all,

just starting this challenge (hot sauces) and the instructions clearly say "... any sauce with an Overall Rating of 5 should be included in the final output".

My first step was to filter for Overall Rating = 5, then Unique on the sauce name, but I get 22 sauces with Overall Rating = 5 whereas the correct solution has just 5 sauces.

What am I missing? I feel so stupid, everyone else gets this right... would be really grateful for any tips, thank you!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703