Duplicate Delete

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


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


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

Hi @Deebiga_Kandasamy

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


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()


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