Compare two DataTables and remove duplicate rows

[Chaitan]

Hello,

I have two datables ,One is main Table which has 100 rows and second is with 30 rows. Need to compare both the tables and remove the duplicate rows from main table which has 100 records. (100-30= 70)
Any leads helpful

Thank you

[kumar.varun2 (Varun Kumar)]

Hi @Chaitan

Have you tried using the Join Data Table Activity.

[Chaitan]

NO! How that works?

[kumar.varun2 (Varun Kumar)]

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

[Chaitan]

Join is giving the matching of records. I want to remove the records from datable

[kumar.varun2 (Varun Kumar)]

Use left join and after that remove rows which have empty values of second table by using the Filter Data Table Activity

[kumar.varun2 (Varun Kumar)]

@Chaitan

You can use this also

outDT = dt1.AsEnumerable().Except(dt2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable

check the attachment
Except.xaml (9.2 KB)

[Chaitan]

Thank you above solution worked