Output File Naming

[heatherpaquette]

I want to replicate a workflow each month but have the description on the output file change from, for example Sep-23 to Oct-23.  Is there an automated way to update this without clicking and manually updating?

[caltang]

You can use the Formula tool to make a new field called "OutputFile"

Have the output path as a string in the formula tool, then add "C:\pathhere\" + ToString([Month Name]) + ".xlsx|||Sheet1" for example.

Then in your output tool, you can change the entire file path and drop OutputFile as a field.

This needs your Month Name to be dynamic - you can do so with either an interface tool drop-down or use "DateTimeNow()" configured to the Month-Year of your choice.

[caltang]

Refer here to something I did for someone else: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Replacing-DCS-with-Alteryx/m-p... 

There's a workflow attached there as well which you can use & study.

[TimN]

Here's a couple of pictures to show one way.  Use a Formula Tool before Output...

[jmo95]

Hi, 

I have been able to use this to generate files with date and time stamps. However, is there a way to exclude the column created from the output file? Currently my excel output has the filename column appearing in the out put.

TIA

[nagakavyasri]

@jmo95 Uncheck this field to exclude from Output: