Unique Tool to return max results

Question

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.

davidskaife · Answer

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)

Unique.yxmd

binu_acs · Answer

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

an example is given below

Summarize_27_07.yxmd

IraWatt · Answer

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

Example.yxmd