Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Champion

create a variable

var= weekday(fieldname)

then use

$(ShareDirectory)File_$(var).csv

hope this helps

Sunil Chauhan