Have each days output (in excel) make its own separate excel file w/ that days date on it?

Question

Hello,

I believe I saw something about doing this somewhere, but I have no idea what to do.

I run the same sales data workflow everyday and it would be perfect if when I run it each morning, it auto creates an excel file with that days date in the file name. So I would have a running batch of sales data files, which I can easily go back into to review by date in the file name.

Today's for example would be Reporting Sales 808/24/22

Not sure if this is a huge lift, but any advice would be super appreciated.

Henry

IraWatt · Answer

Hey @Henry_Gunn,

Creating files with todays date on is quite straight forward. Using the date time functions you can create the dynamic date:

With the date you can then make a file path to create your file using this setting in the output tool:

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

ChrisTX · Answer

Look at this Knowledge Base article

Community > Designer > Browse Knowledge > Saving an Excel File with Today's Date

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Saving-an-Excel-File-with-Today-s-Date/tac-p/344298#M3687

and these posts:

How to: Dynamically rename output files
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Guide-to-dynamically-renaming-output-files/ta-p/27449

Create Multiple multiple worksheets from Multiple Inputs date time stamp appended to file

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-Multiple-multiple-worksheets-from-Multiple-Inputs-date/m-p/307026#M54722

Datestamp to Ouput File name

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Datestamp-to-Ouput-File-name/td-p/596