Creating Dynamic New Folder based on the Month within a constant folder

Question

I have created a file path for some files I would like saved in a dummy folder which I have called 'Outgoing Files'.

My file name will include current [Month].

Is there a way to have my files saved in a folder called August or September within Outgoing Files?

So next month if I run this process I would like all output files for September to be separately saved down.

Attached is a picture with formulas I am working with.

Thanks for your time and apologies if this q has been answered elsewhere.

Capture.PNG

coseni · Answer

so does the file path that i have created have to pasted in the first box in the output tool?

OTrieger · Answer

@coseni

You will need to use Ran Command tool to create a new folder and the output your data, therefore You will need to use the Block Until Done tool to synchronize the sequence of the data output.

You can google which is the Command to create a new folder path with CMD. I'm not attaching any link as there are many websites that explaining which command to use and what is the syntax that you will need to use.

griffinwelsh · Answer

@coseni you need to dynamically generate a column for the desired filepath. You can use the function datetimenow() to add the current month into your path. Then use take take File/Table Name from Field with the output data tool. Sample workflow is attached. You can also use a python script to dynamically create the folders if they don't already exist.

Sample.yxmd