How to find 2 column's duplicate records in excel?

Assign Activity
dtResult | DataType: DataTable =

(From d In dtOrigin.AsEnumerable
Group d By k1=d(1).toString.Trim, k2=d(2).ToString.Trim Into grp = Group
Where grp.Count > 1
Where k1.Equals(k2)
Select g = grp).SelectMany(Function (x) x).CopyToDataTable

we group the rows
when group member count > 1
When

which we check with the key k1= k2

then we return the group members

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

1 Like