Representative Example

Question

I know I am being a dope - and there is an easy way to do this, but I am having a brain freeze.

I have a list of companies.  I have their employee count and their revenue.

I have duplicated companies, but I want to get to a list that shows each company only once - and represents:

A) the one with the most employees

B)  if tied, the one that has the most revenue

C) if STILL tied, I don't care.  One of the tied pairs.(or triplets or whatever.)

So - in the attached example, I have 4 Ashleys.  I want the resulting list to have only ONE - the one with 20 employees.

Thanks

Corey

RankingExample.csv

apathetichell · Accepted Answer

you can sort --- and then use the sample tool in group mode where you select the 1st of each entry.

@Kottapally_Ramesh your strategy would not provide the detail of which entity had the highest value --- only the highest values. You'd need to join with your summarize tool to get entry level detail. You would then have potential duplicates if the max values matched multiple rows. You can avoid this with either the sample tool where you are mandating only one entry is selected --- or by using a sort/tile-tool combo --- where you can use unique mode to find unique entries for the combo and then select tile_sequence_num 1 (the first tile for each tile group).