Use function in store into string

[#1]

Hello,

Does anyone know if it is possible to use a function when you use store into?

Let's say I want the filename to be NameOfFile_20120216.txt

When I try the following QV complains about an "Unknown file format specifier"

store * from Table into D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_'&today()&'.txt (txt, delimiter is ';');

br

Martin

[ekech_infomotio · Accepted solution]

I wouldn't put any functions directly into the store-statement. But you can put your function into a variable

let vExportFilename = 'D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_' & today() & '.txt';

store * from Table into $(vExportFilename) (txt, delimiter is ';');

regards,

Edgar

[jagan]

Hi,

Assign the file path into a variable like this

LET fileName = 'D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_'&today()&'.txt (txt, delimiter is' & char(39)& ';' & char(39) & ')';

Now assign the filename

store * from Table into $(fileName);

Hope this helps you.

Regards,

Jagan.

[giakoum]

Both jagan and Edgar are correct, however you need to format the date otherwise the windows filesystem will not recognise this as a valid file name :

let vExportFilename = 'temp' & date(today(),'dd-mm-yy') & '.txt';

store temp into $(vExportFilename) (txt, delimiter is ';');

BS, Ioannis