I used 2 excel sheets with columns like “Employee Name”, “Designation” and “Status” in Sheet1 and “Employee Name” and “Updated designation” columns in Sheet2. Some Employee Name values in both sheets are same.
Here the scenario is bot has to read both excel sheets and in both sheets if the Employee Name had matched then bot has to write “Updated” in Status column in Sheet1. and if not matched then bot has to write “Not updated” in Status column in Sheet1
In this I took Lookup data table to compare both tables.
In lookup data table I am having confusion in Column Number field. What to give in the Column Number field.
Employee details.xlsx (10.3 KB)
Hi @Vinit_Mhatre here is the excel file, please go through it. The file contains 2 sheets.
Bot has to read both sheets and write the status as updated for matched employee names and not updated for unmatched employee names.
And if you want to see the code I developed, here is the code. Please check it if needed. Main.xaml (4.0 KB)
You can use two for each to compare the data from sheet1 to sheet2. If the data is matched, update as “Updated” and if not, write “not updated”. Check out the attached workflow for your reference. Main.xaml (14.0 KB)