How to compare two data tables and look for not matching row columns?

[Thumu_Suresh]

Hi Team ,

I have two excel’ s need to compare both need remove the not matching row columns .I had tried UiPath activities but it doesn’t help me much because data tables contains with 100 thousand rows,
There is any alternate solution Please help me .

Regards ,
Suresh

[Jobin_Joy]

Hi @Thumu_Suresh ,

Please have a look on the below thread.

How to compare and find not matching item in two data tables?

Hello. I have two data tables with only a column. Most of the row values are same in both data tables. But some values are only in one data table, and some values are only in other data table. I want to compare this two data tables and get mismatching row values. Here you can see an example of data tables: DT1 DT2 Title Register Number 67 21 16 34 34 11 21 23 45 45 11 2 23 87 How can I get this mismatching values?

Thank you.

[Thumu_Suresh]

Hi Jobin ,

In inside the chain there lot of replies .I didn’t get the solution .
Can you please help.

Regards,
Suresh

[rikulsilva (Henrique Lima)]

Hi, Thumu

Try Join Data Tables Activity and add match rules (column from dt_1 = column from dt_2) and choose Inner options. Set new DataTable as output:

doc:

Join Data Tables

[Thumu_Suresh]

Hi Lima ,

It is taking more 40 min to complete .
Can you help me with other alternate solution .

Regards ,
Suresh

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Thumu_Suresh

Full Join - compare datatable 1 with datatable 2 - return matching and not matching items

@Karan28 the Join activity did a good job for doing the full Join [grafik] Linq was helpfully for bring it into the target structure: (From dj In dtJoin.AsEnumerable Let c1 = If(String.IsNullOrWhiteSpace(dj("Column1").toString), dj("Column1_1"),dj("Column1")) Order By c1 Let ra= New Object(){c1,dj("Column2"), dj("Column2_1")} Select dtResult.Rows.Add(ra)).CopyToDataTable [grafik] Find demo XAML here: FullJoin_TotalColResult_JoinActivity.xaml (12.2 KB)

[Thumu_Suresh]

Hi Sangeetha ,

Thanks for the quick response!!!

In my cases there different column Name in datatable(DT1) need to compare with other data table column in dt2 with different column .
We need to compare the both the datatables if any of the row column is matched we need to remove and non matched row column data need to store in other data table.
But data is more than 7 to 10 Lakhs records.
Example

[rikulsilva (Henrique Lima)]

@Thumu_Suresh

Lakhs records

Hi
How much columns do you need to compare?

Can you provide the both excel with fake data ?