add time stamp while storing it in qvw

[saumyashah90]

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

[alexandros17]

Try This:

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

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

[#3]

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);

[maxgro]

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);

[its_anandrjs]

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

[its_anandrjs · Accepted solution]

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

[saumyashah90]

Execution failed

[saumyashah90]

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

[saumyashah90]

This worked fine