Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can you Append CSV files in Qlickview

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

1 Solution

Accepted Solutions
Not applicable

Re: Can you Append CSV files in Qlickview

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

4 Replies
Not applicable

Re: Can you Append CSV files in Qlickview

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

Not applicable

Re: Can you Append CSV files in Qlickview

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

Not applicable

Re: Can you Append CSV files in Qlickview

Can you try the partial reload option

Not applicable

Re: Can you Append CSV files in Qlickview

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

Community Browser