Guys…Can across complicated scenario at least for me…
Process flow…
Read the Master excel sheet → Pick the Emp Code-> Download the Data from web-> Save as with naming (Project Name+Emp Code+ “SAL”) — till this portion I have done…
Now, I have to upload this document to shared folder link provided on the master excel sheet column B…in that case the bot will loop through the Master excel sheet it will search the same name present on the excel and search that document on the folder …
What logic should I apply in this so that it should search and upload the document matching the Emp Code column present on the master excel sheet though the file name is different on folder
I don’t want to add an additional column on excel using concatenate what I want for bot to check for exact document match either it should create a variable and store the naming convention provided above…
Kindly help