Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Exporting to excel using reporting tools

ileopold
5 - Atom

I am trying to export my output into an excel workbook using the reporting tools. Is there a way to make sure it doesn't overwrite the previous export each time I run the workflow?

1 REPLY 1
iCFO
9 - Comet

You might try to create a field with a formula to calculate the current date / time of a workflow run. Then check the "Group Data Into Separate Reports" option in the Render Tool's configuration, select the current time stamp field in the "Field to Group On" dropdown, and select prepend or append the group to file name in the dropdown underneath.

 

Use the "Date Time Now" tool, and set the format to "yyyy-MM-dd hh:mm:ss". I would also convert it to a string and do a Replace formula to remove or replace the "- / :" symbols to get to a more standard file name.

 

It should still only create a single excel file per run, but appending the run time and date will keep it from saving over prior exports. You will still have to clean up the old files manually unless you automate it separately.

Labels
Top Solution Authors