How can I save the output as ddmmyy formate

[Kinetic_analytics]

Hello:

I want to save the output result of the workflow as dd. mm.yy

For instance, the workflow will be saved in a previously formatted excel template with the date stamp on it. 

Output_19.08.22 formate

In the output directory, there will be an output file for the previous day.

appreciate your help.

Thanks

[dYoast · Accepted solution]

Try this.

Add a formula tool.

Then use that new field in your output.  At the bottom, check "Take File/Table Name From field, then choose the field from the formula tool.

You may need to add more to the formula.

[Luke_C · Accepted solution]

Hi @Kinetic_analytics 

Here's a simple example - we can't work with your workflow because you did not include the data. You can do so by going to Options>Export workflow assuming no data is confidential. This will save the output to the same location as the workflow. You can update the period in the formula to include a more detailed file path if needed.

[Kinetic_analytics]

How about I want this output report in pre-populated and designed excel file format? 

[Luke_C]

Hi @Kinetic_analytics 

Look into excel templates. The below posts offer two ways to do this:

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overw...