Directory

Hi Community,

I’m currently using Alteryx 2024.1 and facing an issue with the Directory tool. Under my IMS folder, there are 4 subfolders, but the Directory tool is only picking up 2 MP4 files instead of showing all subfolders.

Specifically, I want to access the FY25 folder, but it’s not being picked up.

Could you please guide me on how to configure the Directory tool so that it can read the required subfolder (FY25) along with the others?

Thanks in advance for your support!

IMG_20250906_022245.jpg

IMG_20250906_022408.jpg

Workflow

Accepted answers

fmvizcaino

Hi @Jp1526 ,

Here is an example showing how to do that. We are using today`s date to look for the folder with the same month. I have also added a formula with something similar with the FY25 if needed, because you will need to identify when to move to FY26.

Best,

Fernando

Example.yxmd

fmvizcaino

Sure!

directory tool.png

Folder-filter: datetimeformat(DateTimeToday(),'%b')

FY-filter: datetimeformat(DateTimeToday(),'FY%y')

Contains([Directory],[Folder-filter])

All comments

fmvizcaino

Hi @Jp1526 ,

You need to select the option to include subdirectories. Keep in mind that only folders with files will show up in your directory tool output.

directory tool.png

Best,

Fernando

Jp1526

Thank you 🙏🏻

Inside my IMS folder, I have 7 subfolders (Jan to July). When I include subdirectories, the tool shows all the Excel files instead of listing them folder by folder.

What I want is to select the FY25 folder, which is located next to my IMS folder (not inside it).

Could you please guide me on how to configure the Directory tool so that it picks the FY25 folder directly, instead of pulling all files from the subdirectories?