Hi @Thomas_R_H
You can do it.
Well I don't have the section where bot need to go to link to download the data, but in the flow i have shown how to do it.
This is the flow
the excel file used for this process
link1 , link2 are link to which bot naviagates to as part of the process
From folder perspective , bot will add the folder in the following way
Logic of how i did it
1. Read the excel file
2. Loop through each row of excel file
a1. set a variable index with value 0
a2. Set a variable folder_path with value of main folder where you need to add the main folder [ folder in first column, in this example, PA]
3. Loop through each column values in that row
Checks whether the column value you are looping is the last one or not [ since it has link], if not follow the below steps
a. while looping through each row, will create the folder using folder_path as folder path and %col% as folder name.
b. next assign folder_path with value folder_path+%col%
If the col value is last, then add the sequence to navigate to the webpage. [ I have added it as comment in flow]
then increment index with value 1
This is the complete logic how to acheive this step. Let me know if you have any questions.
Thanks & Regards,
Nived N
