How to copy duplicated id number and its row values to new excel file

This is my sample data to. and must copy the duplicated id no. to new excel file… I’M USING STUDIOX.
Annotation 2023-02-28 081112

but just copying just 1row per id

Hi @flashdrive07,
Read the data using read range activity to bring the data into datatable and use below linq to get only duplicate records then use write range activity write duplicate records into new sheet.

(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

2 Likes

hi, but i want to copy the duplicated id no and its values then write to new excel then save excel per employee name…
Do you have sample flow for this arivu96?
because im a beginner in UiPath StudioX

Your response is highly appreciated

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