Hi, I want to know how can i get the duplicate rows in excel and paste them to some other excel sheet?? Thanks in advance.

@SHAISTA You have to replace dt with your datatable Variable and assign the result to one more datatable variable** (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.CopyToData…

How to get duplicate rows?

Help

MAHESH1 (MAHESHKUMAR JV) February 23, 2018, 10:19am 10

@SHAISTA
Yes

Regards,
Mahesh

How to extract duplicate values from an excel file and write it into a different excel file in uipath

Find duplicate record

Topic		Replies	Views
How to get/select Duplicated Row in Excel Data Table Activities datatable , excel , activities , studio , question	3	666	July 13, 2023
How do I get only Duplicate Rows From the Excel Data Column? Studio studio , question , activities_panel	6	320	August 5, 2023
Check Excel to contain duplicate row and paste in other excel Studio datatable , excel , uiautomation , studio , question , activities_panel	12	1194	March 31, 2022
Record duplicate cells in Excel Studio studio , question , tools	3	1030	November 19, 2021
Get the Duplicate Rows depending on the conditions Help	9	6115	June 14, 2019

Most Active Users - Yesterday
ashokkarale
Anil_G
ppr
SorenB
sharazkm32
k.sakaguchi0804
sven.wullum1
supermanPunch
sonaliaggarwal47
basavarajbennur07
More details...

How to get duplicate rows?

Related topics