Duplicate rows

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?

Developer

Accepted answers

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 🙂

remove duplicates.yxmd

All comments

hey @TormentMaker

Perfect use-case for the summarise tool :

Please find workflow attached

Hope this helps!¬
TheOC

TormentMaker.yxmd

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 🙂

remove duplicates.yxmd

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.

dupRows_SampleTool.yxmd

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.

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

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!

Thanks @atcodedog05buddy, that worked! 😄

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703