This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need your help with loading multiple excel files into my workflow, but from specific folders.
In my parent folder there is a lot of subfolders containing excel files. However, I do not need the files from all the subfolders, only from some of the folders. More specifically all excel files from folders having "Week" in their folder name.
I have tried to apply a filter tool between my directory tool and macro.
Try it this way. I just added to the directory to look files which have in the folder and all subfolders the word "Week*" (supposing your file starts with the word week). Then in the formula I looked for the same sheet "|||`Sheet1$` (again, supposing al your sheets are named the same).
PD: This only works if all your files have the same amount of columns and column names.
I am able to filter for the folders I need now, thank you. I have also tried to add the dynamic input. but since not all excel files contain the same amount of rows the flow will skip these files. Is there any workaround or modification to the dynamic input tool I can do? I have not worked with that one before.
No, the only way around would be creating a macro. The dynamic input acts as a union tool to copy all your files which follow the same structure. I would recommend you to either set the same format for all files or to create a macro with multiple dynamic inputs (1 for each kind of weekly report you have) and then unite them all with a multiple join tool