Overwrite QVD files

[#1]

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]

pseudo code

load

     year + 2 as year

     ...

from

     yourqvd

store your qvd

[ashfaq_haseeb]

HI,

Try something like this

Load

F1,

Year+2 as Year,

F2,

.

.

.

Fn

From 2010.qvd

store 2010 to 2012.qvd(qvd);

Regards

ASHFAQ

[jagan]

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.