Hi all, How to match single columns from sheet 1 and sheet2 and update the sheet2 data into sheet1. I tried full join, left join but not working. [image] sheet1 [image] sheet2 Expected output. [image] Please help me. How to do this. Thanks, Lakshmi

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”).tost…

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

Learning & Development Programs Automation Starter

rohith.prabhu (Rohith Prabhu) August 12, 2022, 6:09am 16

Hi @lakshmi.mp ,

Did you check this Post :

Regards,
Rohith

1 Like

Topic		Replies	Views
Comparing two excel columns and updating corresponding values Activities datatable , excel , activities , studio	12	2268	May 23, 2022
How to compare two column from sheet 1 to another two column from sheet 2 and check condition to meet.? Automation Starter datatable , excel , uiautomation , robot , activities , studio , studiox , question , activities_panel	9	815	June 6, 2022
Linq to compare 2 excel sheets and select particular column to create 3rd sheet Studio excel	7	3250	March 17, 2020
How to match two data table particular value found update in match row Activities excel , activities , question	7	746	May 16, 2023
Compare 2 sheets using 2 column names and get the uncommon data from 2 files Activities datatable , excel , uiautomation , activities , faq	28	967	May 29, 2023

Most Active Users - Yesterday
ashokkarale
Anil_G
sharazkm32
Steven_ds_55
Karla_Cristina_Santos_Cam
snehamayi.senapati
k-yamashita
mateuszmacheta
Manisha_Ravindra
Vishal_Verma1
More details...

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

Related topics