Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

qvd files

Dear all,

I'm trying to load data from a QVD file, but I don't see my records. I created Myfile.qvd by  STORE Myfile INTO Myfile.QVD.

Then I try to load data by  LOAD * FROM Myfile.QVD, but I don't see anything.

What I'm doing wrong ?

Help please

Thanks in advance

1 Solution

Accepted Solutions

Re: qvd files

hi

You can use it in personal edition also.

Try this,

test:

load * inline

[

product,amount

xxx,56

yyy,78

];

Store test into test.qvd(qvd);

then reload once... After that from script, choose table files and select your  qvd file from the path where it store.. may be file path is problem for you..

you can remove the test table from script because you will get same data from qvd file itself..

hope it helps

7 Replies
nagaiank
Valued Contributor III

Re: qvd files

If your table MyFile had any data and you generated the qvd file using the script

STORE MyFile into MyFile.qvd (qvd);

when you load the qvd file using the script

LOAD * from MyFile.qvd (qvd);

you should be seeing your data.

MVP
MVP

Re: qvd files

First look at your qvd size if it has any data at all. Once sure, that your qvd file has data, then one possibility could be - you have used a DROP command somewhere after the LOAD (from qvd) command, it is not necessary that you drop the same loaded table to lose your table, but sometimes if you are loading two tables with all common fields the later one gets concatenated automatically to the pervious one, therefore if you drop the previous table... you lose your both tables, because there was no second table actually.

see, if this is the case.

Regards,

tresesco

Not applicable

Re: qvd files

I did exaclty the same, but I forgot to mention that I'm using the Personal Edition. Is it possible to use QVD files with this version ?

Re: qvd files

hi

You can use it in personal edition also.

Try this,

test:

load * inline

[

product,amount

xxx,56

yyy,78

];

Store test into test.qvd(qvd);

then reload once... After that from script, choose table files and select your  qvd file from the path where it store.. may be file path is problem for you..

you can remove the test table from script because you will get same data from qvd file itself..

hope it helps

Not applicable

Re: qvd files

Thanks, it works!!!!

Just one thing: is it possible to append new records to an existing QVD file ?

For example:

first loading, all the 2011 records

second loading, all the 2012 records.

At the end, I should have Myfile.QVD with both year.

Thanks in advance

Not applicable

Re: qvd files

Hi

I'm trying to manage a table with 4 million records. So I would like to approach a sort of incremental loading, like load records year by year or month by month

what I mean is this:

test1:

load * from mytable where Yearfield = 2011

store test1 into myfile.qvd(qvd)

When I run the script again, I should have:

test1:

load * from mytable where Yearfield = 2012

store .... I don't know how to append these records to the existing into Myfile.qvd.

Thanks for your help and advices

Re: qvd files

hi

try this ,

tablename:

load * from mytable where yearfield = 2011 or yearfield = 2012;

store tablename into test.qvd(qvd);

hope it helps

Community Browser