Alteryx Designer Desktop Discussions

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

Attachment using the genrated file but using the current date output

Grail030510
8 - Asteroid

Good Day,

 

 Is there a possibility to attached an Excel file with the current date included in it is file name, I want it to be dynamically attach, since everyday I run the workflow and the file name of the excel file has a date on it?

 

Thanks In Advance

1 REPLY 1
DataNath
17 - Castor

Hey @Grail030510, does the daily file follow a standard naming convention? If so then you could make the FileName dynamically in a Formula tool, before appending it to your data stream just before the Email output and referencing this field as the file to grab. Here's how that looks:

 

1) Create the 'base' of your filename

 

1001.png

 

2) Add the date using whatever formatting options you need

 

1002.png

 

3) Append this to the main data stream

 

1003.png

 

4) Reference the FileName field in the attachment options

 

1004.png

 

Hope this helps!

Labels