Hello, I would like some help with a little issue I am having. Not sure if this can be done.
I have a csv file generated every week by an automated process. I want to load this data into Qlikview on a weekly basis, but rather than manipulating the raw file, I would like to append the new data into what is already loaded in my Qlikview file so that I start to build the data repository for some reporting.
What I have tried:
Buffer (Incremental) load
(txt,codepage is 1252,no labels, delimiter is ',',msq)
However, when I do reload the data with the above script, it just overwrites it. Initial file is 30 line, I would expect on the next load to be 60, but it remains at 30.
I created a new QV file and loaded the data from a csv and saved this using the "store" command into a QVD (see code below)
Buffer (incremental) Load
(txt, codepage is 1252, no labels, delimiter is ',', msq);
Store a_text into afile.qvd (qvd);
I then have another QV file that loads the qvd file with just a
Load * from afile.qvd (qvd);
This all works fine. I can see the data that I have loaded, now I load the next file, with the same name, hovever when a new a_text.csv is loaded it just overwrites the qvd file rather than append the data to it.
I am not a great expert of Qlickview so cannot see where I am going wrong!