Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

saving a file with the current date

Highlighted
8 - Asteroid

I create a .csv file at the end of a workflow with a static filename. However, since this workflow will be run daily, I want to add the current date to the end of the static filename. How can I add this feature to the workflow?

Highlighted
12 - Quasar

Hi @cstafford

 

This can be done by adding a "Today" field using Formula tool to your dataset before the Output tool and check the box of "Take File/Table Name From Field" box in the Output tool:

Capture1.PNG

Highlighted
8 - Asteroid

thank you, worked great.

Highlighted
8 - Asteroid

Is there a way to format the date in this without the dashes? I need the date to be YYYYMMDD.

Highlighted
8 - Asteroid

I would try the DateTimeTrim formula and concatenate as needed

 

DateTimeTrim(DateTimeToday(),"month"&&"day")

Labels