Find duplicate record

how to get duplicate record in uipath

Hey!

Try this…

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

References:

Regards,
NaNi

Hi @Yogita_Gaikwad

How about this expression?

(From p in DT.Select() where( From q in DT.Select() where q(1).Equals(p(1)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Here q(1) & p(1) = column index

Regards
Gokul