Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD files

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

1 Reply
Miguel_Angel_Baeyens

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