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.. )
Thanks -
How would this also work if I had extra columns for example:
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?
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.
@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.