Hello. I have two data tables with some columns. Most of the row values are same in both data tables. But some values are there in 2nd data table which are not matching with 1st table Employee details1.xlsx (8.3 KB) Employee details2.xlsx (8.4 KB) . I want to compare this two data tables and dele…

[image] Gokul001: Check out the XAML file JoinDtAndRemove.xaml (11.5 KB) Have you checked this workflow? @Vanitha_VS

How to compare 2 datatable and remove data in 2nd table which are not matching?

Yoichi (Yoichi) November 28, 2022, 5:52am 3

HI,

Hope the following sample helps you.

arrDr = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).ToArray

Regards,

Topic		Replies	Views
How to compare and find not matching item in two data tables? Studio	14	9516	March 4, 2021
How to compare two data tables and look for not matching row columns? Activities excel , activities , studio	8	2346	January 6, 2023
Non match records in datatables Activities excel , activities , question	4	637	April 3, 2023
Compare two datatable Help activities , studio	9	2572	November 27, 2019
Compare two data tables and remove not Matching rows Studio studio , question , workflow_diff	4	2199	January 5, 2022