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

Help StudioX
, ,
1

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

Annotation 2023-02-27 153614
Annotation 2023-02-27 153614418×581 14.8 KB

2

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
3

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

4

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