Extract Folder Name List

I wonder to know how Alteryx can extract folder names in a known path, thank you for everyone who can give me help!

The reality is that there are many folders in one path, and I need to know the names of the folders, but I think the directory tool can only extract the names of files in the path.

Developer

Accepted answers

sparksun

you can create Folder Path and judge if any folder exists or not by using function FileExists( )

I got the solution from the post below：

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Check-if-folder-exists-before-creating/td-p/327972

All comments

Emmanuel_G

Hi @EG_GBM ,

The FileGetDir function can help in this case.

It takes as argument the full path to a file and returns the path to the folder.

You can then easily remove the data to extract only the name of the folder.

Find attached an example.

Extract directory.yxzp

Sarreddy

New Workflow3.yxmd

EG_GBM

Thank you for your prompt reply! But in fact there may no file in the folder, because this task only needs to create folder.

In the real case, I need to create 4 levels folder, and in "Folder2" I need to return to the name of the existing folders (which may not contains any files), and then I can make judgments and do subsequent operations:

1) If the folder I need in "Folder2" has been created, I can create sub-folders inside it.

2)If the folder I want has been not created, I can create the required folder and the corresponding subfolders.

Thanks for you help in advance!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703