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.
alteryx Community

# 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 #325: How many hot dogs can you eat?

7 - Meteor

First time posting my solution here !

As for the other, I don't have the same results on the third question.

Spoiler

22 - Nova

My take on this

Spoiler

9 - Comet
Spoiler

Pivot wide to the required format probably took me most work 😅

5 - Atom
Spoiler

Thanks

5 - Atom

I am not able to post the screenshot and workflow but here are my answers.

1) Who was the winner among the male and female contestants for each year?

 Year Men Hot Dogs Eaten Women Hot Dogs Eaten 2015 Matthew Stonie 62 Miki Sudo 38 2016 Joey Chestnut 70 Miki Sudo 38 2017 Joey Chestnut 72 Miki Sudo 41 2018 Joey Chestnut 74 Miki Sudo 37 2019 Joey Chestnut 71 Miki Sudo 31 2020 Joey Chestnut 75 Miki Sudo 48.5

2) How many hog dogs did the winners eat?

Men - 424 and Women - 233

3) What year had the least number of hot dogs eaten by a man and a woman?

 Men Year Least amount eaten Women Year Least amount eaten 2016 1 2018 4
7 - Meteor
Spoiler

7 - Meteor

Here you go.

5 - Atom

This is my solution, :)

7 - Meteor
Spoiler

8 - Asteroid

All,

Spoiler

This week, I have submitted a 2-for-1, in that I have a long version and a short version of solutions that both work thereby proving that you really can skin a cat two different ways.
The shorter solution focuses more on isolating the numbers required in the end and then utilizing the summation tool for that before cleaning the data later.
-The longer solution focuses on creating and cleaning the table first and then using a smooth and clean table for use by the summation table.
-Nonetheless, both use:

1 Multi-Row Formula
2 Formula
Multiple Data Cleaning Tools