community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Appending Excel Output with Month, Date and Year Dynamically

Highlighted
Asteroid

HI All,

 

I am new to this tool so need all the help i can get!. I am looking to add a month/date/year to the final excel output file name .  this is a weekly run, so needs to dynamically update the dates. Is that possible?

 

Example:

 

File Name : XYZ.xlsx

Rquired FIle Name : XYZ - September 15 2017.xlsx.

 

Thanks for your help

 

S

Alteryx
Alteryx

Hi @sr49ers,

 

Yes, this is possible! This guide details exactly how to make this happen. 

 

Let me know if you have any questions and I'd be happy to help :)

 

Amelia

Bolide

Just putting a shortcut here to the formula used so that next time I can't remember how to do this I'll find it here right away LOL!

 

"C:\FilePath\FileName_"+[FileDate] + ".xlsx|||SheetName_"+[FileDate]

Labels