Linq Query to Update a column depending on the value of another column

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Amrutha.mg ,
You can see

Compare 2 table based on single column and update the values in sheet1 excel

Hi, Please try this using Linq “(From x In dt1 Join y In dt2 On x(“Invoice Doc”).tostring Equals y(“Invoice Doc”).tostring Select tempDt.clone.LoadDataRow(New Object(){x(“SD Order”).tostring,x(“Invoice Doc”).tostring,x(“VA03”).tostring,x(“Status”).tostring,x(“Status1”).tostring,y(“Pdf_data”).tostring},False)).CopyToDataTable” [JoinLinq]

but I think you can activity
regards,