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

[ahmad_sarrawi (Ahmad AL-Sarrawi)]

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”