Duplicate Delete

Help Activities
, ,
1

Hello Guys

I need to delete all the rows that are being duplicated ,Can anyone suggest me some ways to do that

Note: I don’t need a first occurrence also just need to delete that whole number of rows

Eg

I am having a data table with 6 rows in it ,In that col reg no has duplicate values so I need to remove all the occurrence of duplicate value
As simple as that I only need unique reg no with all the row item

Regards
Sudharsan

2

Hi Please refer to this post.

How to find unique values in excel and write the output in excel or txt file - Help / Studio - UiPath Community Forum

3

Hi @Deebiga_Kandasamy

Using the solution in the thread gives me only one column values I need all the row items also

Regards
Sudharsan

4

Thank you @Deebiga_Kandasamy for the reply

I have used this following expression to get all the unique values as well as all the row items.


(From p in Sample.Select() where( From q in Sample.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()

Regards
Sudharsan

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.