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.
Solved! Go to Solution.
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
Hi @DavidSkaife
Thanks for your rply, it's helpful and resolved my issue.
Thanks. It works for me.