We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

How can I save the output as ddmmyy formate

Kinetic_analytics
11 - Bolide

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

4 REPLIES 4
dYoast
10 - Fireball

Try this.

 

Add a formula tool.

dYoast_0-1660927421876.png

 

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.

dYoast_1-1660927475719.png

 

You may need to add more to the formula.

Luke_C
17 - Castor

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.

 

Luke_C_0-1660927692329.png

 

Luke_C_1-1660927706104.png

 

Kinetic_analytics
11 - Bolide

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

Labels