Changing Output File Name Daily using Same Workflow

Question

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.

atcodedog05 · Answer

Hi @JacobGFMR

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

Hope this helps : )

Filename.yxmd

JacobGFMR · Answer

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 · Answer

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 : )

Filename.yxmd