QVD files

Tue, 20 Dec 2011 07:20:17 GMT

Dears

I was created a QVD files from a chart and save in my PC,Now if i want to update data to QVD files from my data base how it would be possibe

As i am new to this area please tell me what are the advantages of using QVD files

If we are working by using a QVW file it is enough or we need to make use of QVD file also

Faisal

Chennai

Re: QVD files

Miguel_Angel_Baeyens — Tue, 20 Dec 2011 07:34:25 GMT

Hi Faisal,

There are a lot of good documents and white papers on why use the QVD files and how. In regards to your question, I'd do a two step load, like the following:

// This loads the existing data in your QVD file
Original:
LOAD *
FROM File.qvd (qvd);
// This loads today data and appends its records
// to the table above
FromSource:
CONCATENATE (Original) LOAD *;
SQL SELECT *
FROM Database
WHERE Date = '20111220'; // Or whatever source or condition you use to get new records
// Now both the old data and today data are stored into the same QVD, so tomorrow
// the LOAD will be the same
STORE Original INTO File.qvd (qvd);

Hope that helps.

Miguel

topic Re: QVD files in QlikView

QVD files

Re: QVD files