community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Append TimeStamp to Output File Name

I think that it would be nice to be able to append a Time Stamp to the name of a file in the OUTPUT Tool, as a Mainframe Programmer I could append a time stamp to file names this is helpful when doing batch jobs that are scduled on a server. 

4 Comments
Alteryx Alumni (Retired)

Hey @Tod, this is available today! At the bottom of the configuration for the output tool is an option to take the filename from a field. With this, you can update or replace the path/filename using fields that come from your data stream. So a formula tool can be placed before the output tool to build up the filename in whatever format you'd like, and then use that field as the output file name. I hope this helps!

output-filename.png

Atom

It seems to work for a CSV file format, but not other excel formats. I did the setups as you explained above. Any clues? Time stamp is field I added with datetimenow() as formula.

xl-setup.PNG

Bolide

Try using a formula to create the full file path, then check the box to change the full path of the file, like this:

 

"D:\Alteryx Temp Storage\DataToSave"+TOSTRING(DateTimeToday())+".xls|Sheet1"

 

appendfilename.png

Meteoroid

This will work but it is somewhat clunky.   The use of a time stamp in output files is common.  Especially in cases were overwriting is not desirable.  It would be nice if that option were available without the necessary prep in advance of the output tool.