Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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