We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Representative Example

CorCor
8 - Asteroid

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

 

2 REPLIES 2
Kottapally_Ramesh
7 - Meteor

Hi,
You can use summarize tool and MAX function to get the highest one. see the attached workflow.

 

Kottapally_Ramesh_0-1756482001290.png

 

apathetichell
20 - Arcturus

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).

Labels
Top Solution Authors