Hi, I have 2 datatables containing data where one column of each datatable has common value to compare. I need to compare both datatables based on both columns and paste the data from datatable2 to datatable 1 Here I have attached the excels containing data DT1.xlsx (9.0 KB) Dt2.xlsx (9.1 KB) …

To get unmatched values from dt1 in final datatable we can use the below code (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1(0).ToString Equals d2(0).ToString Into serialGroup = Group From d2 In serialGroup.DefaultIfEmpty() Select rowNeeded = {d1(0),d1(1),d1(2),If(d2 Is Not…

Comparing values and adding data to one data table

Help Studio

Vikas_M (Vikas M) July 19, 2023, 5:00am 15

@Kunal_Jain
Please refer below link to mark a post as solution

Topic		Replies	Views
Compare two datatables value and update a new column accordingly Studio datatable , studio , question , activities_panel , compare , questions	7	1676	September 5, 2022
Compare two data table and write it Excel sheet Activities datatable , excel , activities , studio , linq	2	367	May 9, 2023
HOW to compare two datatable columns? Activities excel , activities , question	2	1439	August 2, 2022
Linq query to compare two datatable and return values Studio activities , question	5	348	October 10, 2023
Two columns in two data tables are equal then bringing one column value to one data table using LINQ Activities datatable , excel , activities , studio , question , linq	3	326	November 22, 2023

Most Active Users - Yesterday
Anil_G
NIVED_NAMBIAR
sesa499170
class_materials
ashokkarale
Anelisa_Bolosha1
naveen.s
eray_atasoy
Aniesah_Malong
SACHIN_BILE1
More details...

Comparing values and adding data to one data table

Related Topics