Equivalent of 'Directory' for output files

[cchetrusca]

Hi,

Every time I run the workflow, I want to write the output data as a new file (maybe with date within the file name) in a folder and keep the previous output files untouched. The folder with output files may look similar to the one below.  

As today is 20/02/2020, I run the workflow today and should get the file 'OutputFile_2002_2020.xlsx'.  

Please advise.

Many Thanks, 

Constantin 

[DavidP · Accepted solution]

You can create the filename in a formula tool like this:

and then use this option in the Output Data tool

[ChrisTX]

Here's a related post, with a few possible solutions https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Issue/td-p/530747

To create folders, see the workflow workflow "Make Directories.yxmd" in this post

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-new-folder/td-p/54472