How to Separate Duplicate Data?

[Palaniyappan (Palaniyappan P)]

Hi

Welcome back to UiPath forum

Hope this thread will help you get the duplicate records which we write in another excel with write range activity

1. First use a excel application scope and pass the file path as input and get the output as datatable with read range activity named dt

2. Then use a assign activity and mention the below expression in left side and dt in right side

3. Then write dt to a excel with write range activity

How to get duplicate rows for specific column in a datatable

HI @Sunitha_Bist1, Duplicate records from the same data table (From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray).Equals(string.Join(",",p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() Try this one If you want specific Column alone mention the column name (From p in dt.Select() where( From q in dt.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() Regards, Arivu …

Cheers @Perawat