topic Re: Buffer load Issue in QlikView

Buffer load Issue

Tue, 12 May 2015 07:43:07 GMT

I am trying to make an buffer 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. please help me out.

Re: Buffer load Issue

marcus_sommer — Tue, 12 May 2015 12:19:58 GMT

I think you should use the buffer-feature only if you are sure that you have a significant advantage from them. Your missing entry will be probably caused by a not complete fitting load-condition which you should check again.

- Marcus

Re: Buffer load Issue

Tue, 12 May 2015 12:30:32 GMT

check this: Buffer(Incremental) Load Issue

Re: Buffer load Issue

Thu, 14 May 2015 11:17:10 GMT

Thnaks for the reply

...Could you please share an example for the same..

Re: Buffer load Issue

Gabriel — Thu, 14 May 2015 12:16:03 GMT

Hi,

Are you using Stale as part of this option for your BUFFER?

You need to look at this, especially if you are reloading manually.

You can specify as you want it

buffer (stale after 7 days) select * from MyTable;

buffer (stale after 1 hour) select * from MyTable;

Re: Buffer load Issue

Thu, 14 May 2015 13:03:41 GMT

I'm not using stale....I'm just using the below script

buffer (Incremental)LOAD

U_name,
U_pwd
FROM
[Source_path\Buffer.txt]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

\\Buffer.text data

U_name,U_pwd

Jhnk,124

greg,123

Ureg,224

Preg,545

using the above script I'm able to display only first three record...if I add a fifth record to the above text file...only four record are displayed.... the last value is missing every time I load.

Re: Buffer load Issue

Gabriel — Thu, 14 May 2015 13:45:23 GMT

Hi,

The incremental option in Buffer only check the QVD file size which is stored in XML header in the QVD file.

Use FileSize () function before and after adding new records.

Add few carriage returns and see if that make difference