Load multiple files from specific folders

Hi Community!

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.

Hope you can help me.

Capture.PNG

Workflow

Input

Macros

Batch Macro

Iterative Macro

Accepted answers

thllm

Hi Jonas,

I don't believe it can be done with the standard toolset. It can be done using a batch macro though. This post explains how to do so and includes a template macro you can modify.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

All comments

afv2688

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.

Hope it helps

thllm

I think the tool you want is dynamic input.

Use Contains([FullPath],"Week") to filter to only the folders you want. Below is from the included example for the tool. Except instead of North you'll use Week. Then feed into your Macro.

jonasheise

Hi again,

The files does not contain "Week" it is only the subfolders who do that. The excel files have different names.

Is there a way where I use your method, but instead of using the filename, I can filter for the subfolders who contain "Week"?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703