Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!

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

braveraj
11 - Bolide
Spoiler
Saucey Workflow pt2.pngSaucey Results pt2.png
tkemp
7 - Meteor

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. 

olga_strubbe
11 - Bolide

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

Spoiler
Spoiler
Challenge 469_OS.png
MadyeIBT
8 - Asteroid

Spicy fun

wrones104
5 - Atom

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

Spoiler
Screenshot 2025-03-24 150820.png
myastarling
10 - Fireball

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

binuacs
21 - Polaris
Spoiler
image.png
AaronSmatta
8 - Asteroid

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

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

Spoiler
Workflow
workflow.png

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

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-03-25 104249.png