Record duplicate cells in Excel

[Luan_Carvalho_Da_Conceica (Luan Carvalho Da Conceicao)]

Good afternoon people!

I’m removing duplicate cells from Excel, I can already make uipath do this process, but I want to get the record of which duplicates were removed, and this part that I’m not able to do in uipath.

[Palaniyappan (Forum Leader)]

Hi

Have a view on this thread

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 @Luan_Carvalho_Da_Conceica

[Luan_Carvalho_Da_Conceica (Luan Carvalho Da Conceicao)]

Guys, and so was the end result;
1 Assign declaring datatable read range =
(From p in output.Select() where (From q in output.Select() where string.Join(“,”, q.ItemArray) .Equals (string.Join(“,”, p.ItemArray)) Select q ) .ToArray.Count> 1 Select p) .ToArray.CopyToDataTable ()

2 Remove duplicate rows by taking Assign data table declaring read range data table.

3 Output data table getting data table Remove duplicate rows.

4 Append Line taking data table output data table to store in notepad.