How to delete duplicate rows

unknown

Hi Everyone,

I have stuck somewhere while trying to delete rows having duplicate value in a particular column,for example:

Name Rank

A 1

A 2

B 1

B 2

C 1

D 1

Wanna delete A A, B B, keep only C D in my dataset, Can anyone help me to solve this issue.

Thanks in advance.

Help

Accepted answers

davidskaife

Hi @Inactive User

Here is one method: Unique tool on Name, then join both sides of the Unique Tool back together on Name, and utilise the left side of the join output

Remove Duplicates.yxmd

unknown

Hi @DavidSkaife

Thanks for your rply, it's helpful and resolved my issue.

All comments

messi007

@Inactive User,

Please see below :

Attached the workflow,

Regards,

RemoveDup_20220608.yxmd

CarliE

Hi @Inactive User

Attached is a solution!

What this is doing is taking a count of records for each Name, if the record has more than one count, we join back to remove it.

The data you want would be taken from the L output of the join

If you found that this solution works for you, please make sure to mark a solution

Thanks

How to delete duplicate rows.yxmd

davidskaife

Hi @Inactive User

Here is one method: Unique tool on Name, then join both sides of the Unique Tool back together on Name, and utilise the left side of the join output

Remove Duplicates.yxmd

unknown

Hi @DavidSkaife

Thanks for your rply, it's helpful and resolved my issue.

minhdvo

Thanks. It works for me.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703