Need to compare two excels based on single column value and to update matched row in an excel file

manojmanu.rpa · February 7, 2023, 5:23pm

Hi Guys,
i have an two excel sheets
sheet1 input:

sheet2 input:

i need an output in this format

please help with this scenario.

Thanks,
Manoj.

nameless · February 7, 2023, 7:48pm

Use Join Data Tables activity with Left Join type

system · February 23, 2023, 2:47am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
EXCEL DATA TABLE DOUBT Activities excel , question	3	534	February 1, 2023
Compare Excel files to get matching rows based on a specific column Activities excel , activities , question	21	824	April 21, 2023
Compare 2 table based on single column and update the values in sheet1 excel Automation Starter excel , uiautomation , activities , question	19	1268	August 15, 2022
Compare 2 excel sheets data Activities excel , activities , question	3	1013	July 18, 2022
Compare 2 excel sheets and populate matching column with value Activities excel , activities , question	10	984	February 4, 2023