Dynamically update Dates To the Output FileName and Define a Path Where it gets saved

[DataPirate26]

Hello All, 

Can anyone help me out on how to update current date dynamically to the Output FileName and also let the user define a path where it gets Saved. 

[messi007]

@DataPirate26,

Please see this post it shows hoaw to add a date in to file name : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Dynamically-rename-output-fi... 

In order to let the user choose the path you can use an input text with an action to update the path :

User will add the file path using the text box then we update the formula and create the file.

Hope this Helps,

Regards,

[mihaicom20]

Hello,

You have attache an example that is taking the current date dynamically and on the Action toll you can select what part of the folder link to be updated manually by the end user, based on  folder location.

[Qiu]

@DataPirate26 
You can do something like this.

[DataPirate26]

Hi @Qiu @mihaicom20 @messi007 so basically I have to Auto create a Folder Named Output i.e when I will run the workflow a folder named Output Will be created and There a output File named "XYZ 2022-02-07" needs to be created which will have  2 tabs "A" and "B". 

[Qiu]

@DataPirate26 
Creating folder needs to use Run Command Tool.
and where exactly you want this new folder to locate?

[messi007 · Accepted solution]

@DataPirate26,

As @Qiu said you need a cmd to create folder :

Plase take a look on this posts :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-Folders-and-Sub-folders-in-it/t...

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Folder-Creation/m-p/724458/highlight/tru... 

Hope this helps,

Regards,