topic Re: add time stamp while storing it in qvw in QlikView

add time stamp while storing it in qvw

saumyashah90 — Fri, 31 Oct 2014 13:58:12 GMT

Hi All,

L1:

Load * Inline [

A,a

];

Let x= 'Path'&Today();

Store L1 into $(x).qvd(QVD);

this store command doesnt work.Shows script failed after Let command

Can anyone help

Re: add time stamp while storing it in qvw

alexandros17 — Fri, 31 Oct 2014 13:59:45 GMT

Try This:

Store * from L1 into $(x).qvd;

(If you need timestamp use Now() instead of Today()

Re: add time stamp while storing it in qvw

Fri, 31 Oct 2014 14:01:58 GMT

As Alessandro said u need you utilise now() I would advise to store the timestamp in a field and save daily qvd's to reduce physical disc usage

L1:

Load * Inline [

A,a

];

Let x= 'Path'&Now();

Store L1 into $(x).qvd(QVD);

Re: add time stamp while storing it in qvw

maxgro — Fri, 31 Oct 2014 14:04:59 GMT

2 different ways

L1:

Load * Inline [

A,a

];

Let x= 'Path' & date(Today(),'YYYYMMDD');

trace $(x);

Store L1 into $(x).qvd (QVD);

Let x= 'Path' & date(now(),'YYYYMMDDHHMMSS');

trace $(x);

Store L1 into $(x).qvd (QVD);

Re: add time stamp while storing it in qvw

its_anandrjs — Fri, 31 Oct 2014 14:15:12 GMT

One way is directly use the Today() function in store

L1:

Load * Inline [

A,a

1,2

];

//Let x = 'Path'& Today();

Store L1 into 'Path '$(Today()).qvd(QVD);

Regards

Anand

Re: add time stamp while storing it in qvw

its_anandrjs — Fri, 31 Oct 2014 15:11:03 GMT

Another way is to convert today() into DDMMYYYY format without using ( '/' ) in the date format

L1:

Load * Inline [

A,a

1,2

];

Let x = Date(Today(),'DDMMYYYY');

Store L1 into 'L1 '$(x).qvd(qvd);

Regards

Anand

Re: add time stamp while storing it in qvw

saumyashah90 — Tue, 18 Nov 2014 08:13:37 GMT

Execution failed

Re: add time stamp while storing it in qvw

saumyashah90 — Tue, 18 Nov 2014 08:17:08 GMT

It makes QVD but its not taking date in the file name

Re: add time stamp while storing it in qvw

saumyashah90 — Tue, 18 Nov 2014 08:36:36 GMT

This worked fine