I have dt1 with student details and dt2 with only one column “Name” Common column in both dt is “Name” I want two fillter dt like if name of student available in DT2 we need consider it in DT3 For eg. If name John available in DT1 and DT2 “name” column we need to put that entire DT1 row in D3 #h…

Assign Activity: dtResult | DataType: DataTable = (From d in dt1.AsEnumerable Let n = d("Name").toString.Trim Where dt2.AsEnumerable.Any(Function (d2) d2("Name").ToString.Trim.Equals(n)) Select r = d).CopyToDataTable Also have a look on LookUp DataTable Activity

Linq query for compair two datatable and get simmilar values in another data table

Help Activities

Priyanka_Ramesh (Priyanka Ramesh) December 23, 2022, 1:13pm 3

Join Datatable can also be used.

Topic		Replies	Views
How to Get Similar Values from two different Datatables Activities excel , activities , question	3	285	January 12, 2024
LINQ Find matching rows from two datables and copy to results to new datatable Activities datatable , system	6	4031	February 23, 2022
Linq query to compare 2 datatables Activities datatable , excel , activities , studio	3	1588	February 17, 2023
How to get matching data from other datatable with columns Activities excel , uiautomation , activities , linq-query	2	2048	March 21, 2022
On using Linq query on 2 datatables Activities excel , activities , question	6	122	July 18, 2024

Linq query for compair two datatable and get simmilar values in another data table

Related topics