topic Overwrite QVD files in QlikView

Overwrite QVD files

Tue, 04 Nov 2014 08:21:04 GMT

Hi,

I need to overwrite the data in a particular field of a QVD file.

Say the field name is Year and contains 2010,2011,2012 and i need to replace by 2012,2013,2014 resp.

thanks

maxgro — Tue, 04 Nov 2014 08:22:35 GMT

pseudo code

load

year + 2 as year

...

from

yourqvd

store your qvd

ashfaq_haseeb — Tue, 04 Nov 2014 08:28:53 GMT

HI,

Try something like this

Load

F1,

Year+2 as Year,

F2,

From 2010.qvd

store 2010 to 2012.qvd(qvd);

Regards

ASHFAQ

jagan — Tue, 04 Nov 2014 08:30:01 GMT

Hi Deepak,

Try like this

TableName:

LOAD

Field1,

Field2,

Field3,

year + 2 as year

From QVDName.qvd (qvd);

STORE TableName INTO QVDName.qvd;

DROP TABLE TableName ;

Hope this helps you.

Regards,

Jagan.