How to create a dynamic output folder?

I have a workflow that needs to save the reports to a new folder with a date stamp each month. I figured how to date stamp the actual files but don't know how to create the dynamic folder with the date stamp. Hopefully I've attached my sample workflow correctly. I just need help creating the folder \Dynamic 20170719\. I hope I've explained myself correctly. Thank you! Monica

Dynamic folder.yxzp

Help

Accepted answers

patrick_digan

@mocalvo I would use the MKdir command and create a temp bat file to do that. I've attached a working version on my end. You can tweak the formula tool to get the folder naming convention just right. I wasn't sure if you wanted a monthly or daily folder, and whether you wanted the dashes in the folder name. You can use the DateTimeFormat function if you wanted to get rid of the dashes in the folder or file name.

EDIT: the first file had a small issue with the data coming into the append tool. It has been corrected.

Community Dynamic Folder.yxzp

All comments

patrick_digan

EDIT: the first file had a small issue with the data coming into the append tool. It has been corrected.

Community Dynamic Folder.yxzp

mocalvo

Thank you so much for such a quick response! The workflow worked great on my end to create the folder. I just need to figure out why all of my data didn't work it's way to the final file. Only one row was populated. Thanks!

tazeen

Hey, I am getting the error "Error: Run Command (50): The external program "%temp%bat.bat" returned an error code: 1"

How can I fix this?

EtamSoko

@patrick_digan

Hi Patrick,

I found this older thread regarding dynamic output folder and I was wondering if you could help me with a case that might be related to this one.

I have a dataset with including 200 vendors and their related activities. Each vendor has a unique vendor code im my dataset. I would like to separate the dataset for as many excel files as many vendors I have in the dataset and include their respective information.

Is it possible to achieve in similar way to the case below?

thanks very much for the help in advance!

Regards,

MateK

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703