Keep the highest count during a specific date

rxak

Hello!

I have a dataset, where I have used the Summarize tool to count different weather type during a day (Storm, Fog, Cold, Snow etc.). I would like to keep the Type where the count is the largest. 

My dataset

Date	Count	Type
2016-01-02	4	Cold
2016-01-02	41	Fog
2016-01-02	2	Snow
2016-01-02	3	Cold
2016-01-03	1	Cold
2016-01-03	17	Fog
2016-01-03	4	Snow

Expected outcome:

Date	Count	Type
2016-01-02	41	Fog
2016-01-03	17	Fog

Thank you in advance!

DataNath

Hey @rxak, to do this you can just conduct a join back with the main data set based on the date and the max count equalling the count:

Match Type based on max count.yxmd