Dynamically select folder for output file

[Analytics_Pooja]

I am working on a workflow where I need to create a new folder every month and save the output file in that folder. If the workflow is run twice or thrice in the same month then no new folder should be created. 

The folder name is to be picked from the name of the output file. For example statement_20190118 should be dropped in the folder 20190118.

Steps to follow:

Folder name to be picked from the output file

look for existing folders

If the folder exists then save the out

other wise create a new folder and save the out in the new folder.

Is this possible in alteryx.  

Best

Pooja 

[dkma]

Hi @Analytics_Pooja , 

Does the file name always contains as the same format mentioned ?

[Analytics_Pooja]

Yes, file name will always be the same format.