Duplicate rows

[TormentMaker]

Hi everyone, i'm new using alteryx designer and i'm doing a project with it, but i'm having some kind of a problem with one of my tables, it does have duplicate rows that aren't exactly the same, here is an example: 

Character	Money	Date
Lucy	19	05/jul
Kwamma	20	05/jul
Lucy	18	05/jul

Up there, i want to delete the duplicate rows of Lucy as a example, but only the one with the biggest value, letting the one with the smallest value on the table

Someone could know how to do this?

[TheOC]

hey @TormentMaker 

Perfect use-case for the summarise tool :

Please find workflow attached

Hope this helps!¬
TheOC

[atcodedog05 · Accepted solution]

Hi @TormentMaker 

This can be easily done with use of sort and unique tool/sample tool.

1. Sort the Value by descending

2. In Sample tool set first row, groupby as name and N=1 (keep only first row)

    or

2. In unique tool set grouby as name (keep first occurrence)

Sorting is key since it keeps only the first row occurrence 

Hope this helps 🙂

[BonusCup]

UPDATE:  I re-read your post and you are wanting to remove the one with the higher money total.  In the sort, change the Money to Ascending.

You can use the Sort tool and then the Sample tool.

Attached is the sample workflow.

[mceleavey]

Hi @TormentMaker ,

@TheOC 's takes account of the requirement for the larger of the money values.

@atcodedog05 , you'll need to add a sort descending on money to yours to account for the first instance being lower.

M.

[atcodedog05]

Hi @mceleavey 

Nice catch ! I accidently sorted on date instead on money 😅

[TheOC]

hey @TormentMaker 

I only just noticed you want the minimum, you just need to change the action to "min" on the money field in the summarize tool:

Hope this helps!

[TormentMaker]

Thanks @atcodedog05 buddy, that worked! 😄

[TheOC]

Glad you got it sorted @TormentMaker !