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

Help Activities
, ,
1

Hi everyone!

I want to find duplicate records. I have to look 2 cloumns in excel.
Column B and Column D must match each other. How can I do it?

image
image956×216 5.64 KB

2

HI @ozgecatak

Can you share the Output here

3

HI @ozgecatak

You can try with LINQ

(From d In DtBuild.AsEnumerable
Group d By k=d(1).toString.Trim, k2=d(3).ToString.Trim Into grp = Group
Let ra = New Object(){grp.First()(0),k,grp.First()(2),k2}
Select r = DtOutput.Rows.Add(ra)).CopyToDataTable

Regards
Gokul

4

image
image953×94 3.32 KB

Hii Gokul!

The result should be like this.

5

Can you explain this query more?

6

@ozgecatak
1.Read the Excel sheet using Read range and store in DT
2.Use For each data table activity to loop the rows
2.1. Use if condition

CurrentRow(1).Tostring.trim=Currentrow(2).Tostring.trim

2.2. If Both values is the same, the process will go to then sequence, otherwise else sequence.

1 Like
7

Check out this thread @ozgecatak

Regards
Gokul

1 Like
8

Hi @ozgecatak

Check out the Skeleton XAML

GroupByLinq.xaml (8.4 KB)

image

Regards
Gokul

9

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
10

HI @ozgecatak

Checkout this expression

(From p in dt.Select() where( From q in dt.Select() where q("Column name1").Equals(p("Column Name 1")) and q("Column Name2").Equals(p("Column Name 2")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

image
image1151×371 19.9 KB

From p = p is an actual dt from that p.select where( From q “q is a clone dt”) .select from that
q(“Col1”).Equals(q(“Col1”) and q(“Col2”).Equals(q(“Col2”) select those values from q . ToArray.Count>1 Select those values from p datatable ).ToArray. Copy those values to datatable

Regards
Sudharsan

11

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