topic Re: Directory in Alteryx Server Discussions

Re: Directory

fmvizcaino — Fri, 05 Sep 2025 21:01:50 GMT

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.

Best,

Fernando

Re: Directory

Jp1526 — Fri, 05 Sep 2025 21:11:47 GMT

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?

Thanks a lot for your support!

Re: Directory

fmvizcaino — Fri, 05 Sep 2025 21:20:42 GMT

Would you like only the folder name or the files inside this folder? The directory tool is used to list files, not folders.

Let me know your use case and I will see what options you may have.

Best,

Fernando

Re: Directory

Jp1526 — Fri, 05 Sep 2025 21:29:04 GMT

My folder structure is:

IMS

└── FY25

├── Jan

├── Feb

├── Mar

├── Apr

├── May

├── Jun

├── Jul

└── Aug

Each month folder contains around 7 Excel files.

What I want:

1. Alteryx should automatically go into the current month’s folder (e.g., this month → Jul, next month → Aug).

2. Inside that folder, only pick the Excel files where the filename starts with “xyz”.

Could you please suggest how to configure the Directory/Dynamic Input so it can dynamically select the correct folder each month?

Thanks a lot for your guidance!

Re: Directory

fmvizcaino — Fri, 05 Sep 2025 21:40:40 GMT

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

Re: Directory

Jp1526 — Fri, 05 Sep 2025 21:51:21 GMT

Sorry to ask you can you share the screenshot i cannot see in Android mobile 🥲

Re: Directory

fmvizcaino — Fri, 05 Sep 2025 21:55:45 GMT

Sure!

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

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

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