How can only keep the biggest amount and delete the remeaning?

Question

Hi guys - Not sure if is possible to complete the below request in Alteryx, but here we go.

I would like to keep the highest number in the column Quantity with the highest number in the column Version and, at the same time remove the duplicates ( lowest number )

Thanks in advance. ( I've been looking around for a solution for quite some time.. )

alexnajm · Answer

@weslleyroque you keep changing the parameters of the question, so it's hard to provide an answer. In addition, the logic is still inconsistent - for example, why is Time for the second row now 13:00 and not 15:00?

To best help, please provide the data in an attachment (not a screenshot) so we can easily work with the values, and consistent logic to determine what needs to be kept.

My suggestions from above should still hold - adding Second Name as another Group By and Time as a Max should do the trick. If not, please provide what it is doing and what you're expecting.

weslleyroque · Answer

Yes, you are correct should be 17:40.

Tbh we can use the highest version and remove duplicates, which would also help, but when I do that using the summarize tool I'm still getting the highest version plus the lowest

The below example explains a little better what I'm looking for.

apologies for any confusion.

alexnajm · Answer

You can add Second Name as another Group by... but I am not sure your Time column follows in the Max logic consistently. Shouldn't the Time for the second row be 17:40?