Changing Output File Name Daily using Same Workflow

[JacobGFMR]

I have a workflow created obtaining data from a database for current day and I am wanting to save the output file to a specific name daily while not overwriting the previous day's output file.

-Workflow obtains current day data. The workflow never changes, only the query pulls in current day data from the database. 

-Output is saved as "Book 1" for that day. 
-I do not want to overwrite "Book 1" on the following day

-For example, I would like to have the file saved as "Book 1 - 01-06-2022" on current date and then "Book 1 - 01-07-2022" on the following day. 

Thanks. 

[JosephSerpis]

Hi @JacobGFMR check out this how to guide it will help you with your challenge.

[atcodedog05]

Hi @JacobGFMR 

here is how you can do it

1. Generate filename in formula tool

2. Configure output tool like below to output filename as set in formula

Workflow:

Hope this helps : )

[JacobGFMR]

Thanks for the information. That does help rename the file.

It saves the file to the same location the workflow is saved in. 

How can I change the path to save the file elsewhere? 

[atcodedog05]

Hi @JacobGFMR 

Specify the path here. This will set the path for the output files.

Hope this helps : )