Alteryx Designer Desktop Discussions

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

output to have date correctyl

Hi2023
8 - Asteroid

Hi, 

 

I was able to get the date to show but now its showing double on whre the file is landing-can you asisst?

 

currently:

 

YJS_DOD_CAS_Completeness_Score.xlsx|||._YJS_DOD_CAS_Completeness_Score2023-04-17

 

desired output

 

YJS_DOD_CAS_Completeness_Score2023-04-17

6 REPLIES 6
binuacs
20 - Arcturus

@Hi2023 Can you give some more clarity of what exactly you are looking for? 

Hi2023
8 - Asteroid

I am using a formula tool and creating filename 1 with this:

 

[Filename]+DateTimeFormat(DateTimeToday(),'%Y')

 

then on output there is the filename I am doing TakeFile/Tablename from field

and selecting change file/table name

and field containing Filename or part of File name

Filename1 

 

but its giving duplicate filename with one 1 date so date part is fine but I dont want double filename

Christina_H
14 - Magnetar

For Excel outputs, Change File/Table Name changes the name of the sheet, not the whole file.  Try creating the whole file path in your formula and choosing Change Entire File Path.  You'll need to include a sheet name too, ...Folder\FileName.xlsx|||SheetName

Hi2023
8 - Asteroid

Can you explain what you mean by changing the whole path name in formula?

 

binuacs
20 - Arcturus

@Hi2023 Attaching a sample workflow for your reference

 

binuacs_0-1681830386589.png

 

Hi2023
8 - Asteroid

TY!!!

Labels