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

AYXAcademy
Alteryx
Alteryx

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

 

Every 4th of July since 1972, the Nathan's Hot Dog Eating Contest has been held in Coney Island, a neighborhood of New York City. Nathan's promoters claim that on July 4, 1916, four immigrants held a hot dog eating contest at Nathan's Famous stand on Coney Island to settle an argument about who was the most patriotic.


After this weekly challenge, you might want to eat a hot dog or perhaps not, but either way, you will have fun finding out who eats the greatest number of hot dogs.

Using the dataset provided, answer the following questions:

 

1) Who was the winner among the male and female contestants for each year?
2) How many hot dogs did the winners eat?
3) What year had the least number of hot dogs eaten by a man and a woman?

 

 

Thank you for your comments. The start file has been updated.

IraWatt
17 - Castor

Nice Challenge didn't quite get the same results as the outputs. Looking forward to seeing what others did.

Spoiler
IraWatt_0-1656336173217.png

 

Aaron_Harter
11 - Bolide

Happy 4th of July!

Spoiler
0.jpg
dsmdavid
11 - Bolide

Feeling a bit rusty, might need some of that hotdog grease... Slightly different numbers for the # hotdogs per winner (think the sorting was not right in the proposed output)

Spoiler
dsmdavid_0-1656336711091.png

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1656337626754.png

 

Agree with others on the provided output not being correct

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
325.png
danagabiti
5 - Atom

This was fun!

Spoiler
DA_SOLUTION.PNG
AkimasaKajitani
16 - Nebula
16 - Nebula

My solution. I didn't use Join tool.

 

Spoiler
AkimasaKajitani_0-1656341223617.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1656341513616.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1656341963644.png