Unique Tool to return max results

[dhakim1996]

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. 

[IraWatt]

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.

Then use the Unique Tool:

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs]

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

an example is given below

[DavidSkaife]

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:

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