How to delete duplicate rows

[Inactive User]

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.

[messi007]

@Inactive User,

Please see below : 

Attached the workflow,

Regards,

[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

[DavidSkaife · Accepted solution]

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

[Inactive User · Accepted solution]

Hi @DavidSkaife

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

[minhdvo]

Thanks. It works for me.