Can you Append CSV files in Qlickview

[#1]

Hello, I would like some help with a little issue I am having. Not sure if this can be done.

Problem:

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

     @1,

     @2,

     @3,

From

c:\a_text.csv

(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.

Any ideas on how or where I am going wrong?

Many thanks.

Roberto

[#2]

This may help...

You could create a seperate QV document which loads in the data from the csv file

Add a peice of script to the end of the file to store all the data into a QVD

"store 'csv_data' into table.qvd"

Then on your QV file you can load the fields from the QVD

LOAD

@1,

@2,

@3

FROM table.qvd

[#3]

Thanks, so....

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

@1,

@2,

@3

From

c:\a_text.csv

(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!

Thanks for your help.

Roberto

[#4]

Can you try the partial reload option

[#5 · Accepted solution]

Partial reload does not seem to do any thing.

However I tried the following addition to the script after the first load was done and this seems to have done the trick.

Concatenate Load * from afile.qvd (qvd);

Store a_csv into afile.qvd (qvd);

thx