I have a Workflow that involves:
- Excel sheet with multiple names in a column some of the names are repeated multiple times.
- I log into a web site and use a for each to pull the name from the excel sheet which then opens up that names profile page
- Once the profile page is open the birthdate of that name is extracted and stored in a variable
- The last part is the birthdates that were pulled are then added to the birthdate column in the excel sheet.
Problem.
Like mentioned above there are many names that are repeated, so when the name comes up again the process is repeated again for the same user even though that value has already been extracted. Is there way to go through the excel sheet and add that birthdate value for all the names that are the same without having to run the process again?
The robot would get the birthdate from the webpage write it to the birthdate column and check to see if that name is repeated in the same excel sheet and if so copy the birthdate into that birthdate column. I have attached a sample excel sheet for reference.
Thank You Book1.xlsx (10.0 KB)