How to update values from one excel workbook to another workbook wrt respective column

I uploaded a sample excel sheet 1, First, I need to verify its status, including the rows which have verified status, Some data are missing in Excel sheet 2, so the missing data is provided here, we need to update it in the Excel sheet 2 in the respective col. so how to update the value from excel sheet 1 to excel sheet 2 wrt to the column, both the excel sheet will have common patient id based on it, we will compare and update to the specific column

You can use lookup datatable activity.


Refer this doc for how to use lookup datatable activity in this kind of similar scenario

Cheers @Premkumar_Ganesan

Thanks bro!!

1 Like

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