Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Buffer(Incremental) Load Issue

Hi, I am new to Qlikview and am trying to make a incremental load from a csv file. But every time I reload, the last entry from the file is missing. If I load normally, everything works fine. Anyone has encountered the same problem? I assume I got some basic concept wrong but I just couldn't find an answer in this forum. Any help will be appreciated

1 Solution

Accepted Solutions
Not applicable

Re: Buffer(Incremental) Load Issue

Hi Trey,

     Thank you for your pointer. I finally found out the problem. Qlikview seems to count the number of entries by carriage returns. Previously in my country.csv there was two lines but only one carriage return. After appending one extra carriage return at the end of my csv file, I am able to solve the problem.

Regards,

Xue Bin

5 Replies
Highlighted
d_pranskus
Contributor III

Buffer(Incremental) Load Issue

Hi

Would you include the actual CSV file and your script?

Cheers

Darius

Not applicable

Re: Buffer(Incremental) Load Issue

Hi Darius,

     I have attached my csv file here. It's just a simple file with 2 lines.  My script is as follows:

Buffer(incremental)LOAD

     @1 as Country,

     @2 as State

FROM

country.csv

(txt, codepage is 936, no labels, delimiter is ',', msq);

Regards,

Xue Bin

trey_bayne
Contributor

Re: Buffer(Incremental) Load Issue

Incremental load is looking at file size. That file size is stored in the xml header of the qvd. Looking at the .csv file you've sent, Windows doesn't recognize a difference in size when you add one line of data with two columns. QVD's might store more granular data. You can check the size of the QVD using the FileSize('path_to_filename') function.

Something else I noticed, you have a comma and then a space in you second line in your .csv. It seems that your second column isn't being recognized as a column. Try taking out the space in front of KL and try again.

Not applicable

Re: Buffer(Incremental) Load Issue

Hi Trey,

     Thank you for your pointer. I finally found out the problem. Qlikview seems to count the number of entries by carriage returns. Previously in my country.csv there was two lines but only one carriage return. After appending one extra carriage return at the end of my csv file, I am able to solve the problem.

Regards,

Xue Bin

Not applicable

Re: Buffer(Incremental) Load Issue

Hi, I know its been a while, but I´m trying to solve a similar problem.

Did you manage to solve your issue about the incremental  .csv  load?

Do you need to use a   .qvd  file?

Thanks in advance

Santi