I’m using a filtering expression like DT1.AsEnumerable.Except(DT2.AsEnumerable, System.Data.DataRowComparer.Default).CopyToDataTable() and it is working well but, I want it to perform the operation based on two cols only like based on Emp No and Emp Name only this should be done it shouldn’t consid…

Hello @cybzom You could try something like this DT1.AsEnumerable().Where(function(row) DT.AsEnumerable().Select(function® r.Field(Of Int32)(“ID”)).Any(function(x) x = row.Field(Of Int32)(“ID”))).CopyToDataTable do you want to compare two columns with each other or two columns seperately ? [im…

Why did u revoke it sir @vickydas ??

@cybzom With a Join Statement you can define the Common rows on the 2 column Base. The result of IT can be used later for an except on dt1 or dt2

[image] vickydas: DT1.AsEnumerable().Where(function(row) DT.AsEnumerable().Select(function® r.Field(Of Int32)(“ID”)).Any(function(x) x = row.Field(Of Int32)(“ID”))).CopyToDataTable it’s not very clear sir can u elaborate it?

for a datatble with a lot of records performing a join operation and then filtering is going to take a lot of time… is there any other way??

I cant confirm this, a Lot of records is a vague, relative Volume description. And internal linq ist doing even iterations and filterings From coding Viewpoint, you can write your custom datarow comparer Another techniques is to build Key Arrays from the Data and doing similiar as your Stateme…

It’s not working… can u share workflow

Thnx… all I’m trying to do is I have 2 datatables…ok say A and B… I want to see what extra datarow B has that A doesn’t have so I’m using except but, that’s considering all the columns in the datatable to get the job done so i want to know if it can work only for certain cols… any idea from ur side…

@cybzom Your starting right, with the except approach. The Rest to do ist still aß mentioned above

How to consider only certain columns while data table filtering?

Help

cybzom (Kiran Saminathan) December 28, 2019, 5:35pm 2

@Lahiru.Fernando sir can u plz take a look??

Topic		Replies	Views
Filter DataTable1 by excepting rows from DataTable2 by comparing specific column Activities activities , question , other	2	352	December 13, 2023
How to Compare Two Datatables Activities question , other	12	2433	November 16, 2023
Comparing the two datatables for exception of common value Activities database , question	1	561	January 10, 2023
Comparision report Studio studio , question , activities_panel	5	233	May 9, 2024
Compare first column of two datatables Studio studio , question , activities_panel	8	402	September 15, 2023

How to consider only certain columns while data table filtering?

Related topics