Hi,
I save output data daily by manually changing the file name each time. I’d like to understand how to automate this process so the file name updates with the current date and time—without overwriting previously saved Excel files.
Hi @shahnawaz_khan the Output Data tool has the option in the configuration window to take Take File / Take Name from field. Meaning you can build out your filepath with a datetime stamp using the datatimenow() formula within a formula tool as a column/field. Which you use in the Output Data tool.
You can use the formula tool to create your preferred file path/file name/sheet name, etc, meaning you can have a timestamp in it. Then you can use the file path to the output/render tool to automate your process
@shahnawaz_khan - Leveraging the approach that @JosephSerpis & @dreldrel described, I've built out a quick workflow to illustrate and show how this is done. See below and attached. -Jay
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |