Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Unique Tool to return max results

dhakim1996
7 - Meteor

Hi I am trying to use the unique tool to filter out duplicate invoice number and keep the lines with max number. However, upon using the tool the unique tool returns the non-duplicated invoice number but not with the max amount. Any tips on this?

 

Thank you. 

 

 

3 REPLIES 3
IraWatt
16 - Nebula

Hey @dhakim1996,

The Unique Tool takes the first non duplicate row it finds. One option to ensure that you get the MAX ammount is to Sort your data first.

IraWatt_0-1658914743639.png

Then use the Unique Tool:

IraWatt_1-1658914789675.png

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

 

binuacs
16 - Nebula

@dhakim1996 Instead of Unique tool use the Summarise tool , Group by  the invoice number and select MAX of amount 

an example is given below

 

binuacs_0-1658915030594.png

 

 

DavidSkaife
11 - Bolide

Hi @dhakim1996 

 

The unique tool will bring through the first instance of multiple records, so in order for you to make sure you're getting the ones with the max amount on you'll need to sort the data first; please see the attached:

 

DavidSkaife_0-1658914846727.png

If i've not understood the question correctly please can you share some more details (data, workflow etc)

Labels