Output report name with specific date format

[Kinetic_analytics]

Hello Great people:

I want output report save in specific date format(Report_"+DateTimeFormat(DateTimeToday(),'%y%m%d')+".xlsx|||Summary") and file name in the drive. How can I achieve that? I have used this way

Appreciate your help.

[DataNath · Accepted solution]

Hey @Kinetic_analytics, when you build the name in your Formula tool, just add the drive location as well as part of it, like so:

Then, in your Output Data tool, select any location/filename you like (doesn't matter as it'll all be replaced by the field you made), and then configure the options in the bottom left in the same way as below - Alteryx will then replace the save location and the file/sheet name etc with what you have constructed in the Formula tool:

Output:

[messi007]

@Kinetic_analytics,

Please see below :

In the output tool you can select take file name from field :

Attached the workflow,

Regards,

[Kinetic_analytics]

Cool! you are awesome! Thanks for helping me on my learning process. :)