How to load additional data without erase old one

Fri, 22 Apr 2011 17:38:44 GMT

Hi, simple question here, when I load second csv file, the program erased all my old data and charts become blank. How can I avoid that?

Thanks,

Shiping

How to load additional data without erase old one

pover — Fri, 22 Apr 2011 17:50:13 GMT

The short answer is to do a partial reload if you want to keep the data that was previously loaded and add new data with another reload. Search for partial reload in the help.

However it is hard to always depend on partial reloads. A better approach would be to save the csv files you are loading as QVD files in the script with store function (or just one QVD file) and then load that QVD file with the previous data, concatenate the new CSV file to that, and save the complete data over the old QVD file everytime you do a reload.

I don't know why you are loading one CSV at a time, but you can also load multiple table files that have the same structure using wildcard symbols to refer to the file name. (e.g. Sales*.csv)

Regards

topic How to load additional data without erase old one in QlikView

How to load additional data without erase old one

How to load additional data without erase old one