QVD files

[#1]

Hi all,

I have a qlikview app which loads all the data from QVD files.

I need to add few columns and update the records and i dont have data stored in any other format(excel or csv).

How can i do that?

Basically how can i update/modify the QVD files???

Thanks

[alexandros17]

The only way you have is loading the qvd, modify, update it and store it again.

Hope it helps

[Anonymous]

Deepak,

You can load your qvd files, modify the loaded data if you require, and then you can store it as a qvd file again in case you will need it for next loading.

Marc.

[#4]

i dont have any other source for data. just the QVD files.

can we modify the QVD file??? and how do we do that???

or else can we convert it into any other format(say csv or xlsx)

[#5]

how do i modify it??.. i need to add a column

[alexandros17]

Simply

MyQvd:

Load * from xxx.qvd;

At this point you can modify it as any other table.

You can save the resulting table as qvd again or as csv

[Anonymous]

the info you have to add is in another qvd, external sorce or is it a fixed value or calculation from field you have....?

[#8]

its just another column which i have in excel sheet

[martinpohl]

try this:

for each file in filelist('qvd\*.qvd');

trace $(file);

Data:

load *

//here add your new fields

from '$(file)' (qvd);

store  Data into '$(file)' (qvd);

drop table Data;

next

If the new field contains data from another file join it or use applymap

Regards

[#10]

thanks for that but i m new to qlikview and i m not able to understand that..

could you please break it for me