Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #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
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
17 - Castor
17 - Castor

My solution. I didn't use Join tool.

 

Spoiler
AkimasaKajitani_0-1656341223617.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1656341513616.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1656341963644.png