topic Re: 'Store' QVD with current date? in QlikView

'Store' QVD with current date?

dinicholls — Thu, 18 Dec 2014 11:52:47 GMT

Hi,

I have a simple script that stores my info into another table.

My question is, is there anyway of adding the current date to that file name? For example, and I don't know if this is the right way of doing it, but I'm hoping my example will give you the idea of what I'm trying to do!:

store Daybooks into Daybooks_+Today().qvd (QVD);

Does that make sense?!

So, if I run the app today, my QVD file would be called:

Daybooks_18-12-2014.qvd

Is there a way of doing it?

Thank you!

Re: 'Store' QVD with current date?

Thu, 18 Dec 2014 11:55:57 GMT

set a parameter with the desired filename and include the date in it in the desired output format

then write the file with name as the parameter

Re: 'Store' QVD with current date?

amit_saini — Thu, 18 Dec 2014 11:59:23 GMT

Diane,

you can do something like below:

Test:

LOAD

'$(vPlant)' as Plant,

SQL SELECT

NSPCIDNR,

NTOOLNR,

NSTPNR,

NPERS_IDNR,

NLFDSTATIONNR,

NLFDMASCHNR,

NLFDLINIENR,

DTTSPROBE,

DTTSERF,

NSTPFEHLERFLAG,

DTO,

DTU,

DXQ,

//NKORRNR,

SZUSINFO1,

SZUSINFO2,

SZUSINFO3,

SZUSINFO4,

SZUSINFO5,

SZUSINFO6,

SZUSINFO7,

SZUSINFO8,

SZUSINFO9

FROM $(vPlantAutor).STICHPROBE

WHERE DTTSERF > to_timestamp('$(vLAST_LOAD_TIME)', 'DD.MM.YYYY HH24:MI:SS');

Thanks,.
AS

Re: 'Store' QVD with current date?

amit_saini — Thu, 18 Dec 2014 12:02:38 GMT

Here vLAST_LOAD_TIME= today()

Thanks,
AS

Re: 'Store' QVD with current date?

Thu, 18 Dec 2014 12:02:48 GMT

so something like this (not tested)

set vFileName = 'File_Name'&'_'& date(today(),'DD-MM-YYYY');

store table into $(vFileName)(qvd);

Re: 'Store' QVD with current date?

Michiel_QV_Fan — Thu, 18 Dec 2014 12:11:28 GMT

A 2 step approach

1st: let vFiledate = date(today(), 'YYYY_MM_DD');

2nd

Tablename:

Load *

from .... ;

store Tablename into Tablename_to_qvd_$(vFiledate ).qvd (qvd);

Re: 'Store' QVD with current date?

sundarakumar — Thu, 18 Dec 2014 12:13:12 GMT

Hi,

PFA.

We would need the replace since we cannot use / in QVD name.

let variable=replace(today(),'/','-');

one:
load * inline
[a
1
2];

store one into one_$(variable).qvd(qvd);

Thans,

Sundar

Re: 'Store' QVD with current date?

Thu, 18 Dec 2014 12:21:05 GMT

or vFolder= 'MyFolder'& today()

then use it when storing your table, for example

store table vFolder into MyFolder.qvd(qvd)

Re: 'Store' QVD with current date?

dinicholls — Thu, 18 Dec 2014 15:39:05 GMT

Hi Felix,

Worked wonderfully!

Thank you!!!

Another snippit of code I shall be nothing down!!

Happy Christmas / Holidays / Time Off / Doing Nothing Days, (delete as appropriate!)