Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weekday in filename

Hi all!

I'm working on a script, that saves a table in a certain directory. Now I want the file to be named including todays weekday.


For example: File_Monday; File_Tuesday etc...

The store command ends like this:

INTO $(ShareDirectory)File_Weekday.csv (ansi, txt, delimiter is ';', embedded labels);

Can anyone help me, what to fill in, to get the right day?

Thanks in advance

Peter

1 Reply
SunilChauhan
Champion II
Champion II

create a variable

var= weekday(fieldname)

then use

$(ShareDirectory)File_$(var).csv

hope this helps

Sunil Chauhan