Directory

[Jp1526]

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!

[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.

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?

Thanks a lot for your support!

[fmvizcaino]

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

[Jp1526]

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! 

[fmvizcaino · Accepted solution]

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

[Jp1526]

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

[fmvizcaino · Accepted solution]

Sure!

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

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

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