topic Re: Buffer on a preceding load in QlikView

Buffer on a preceding load

Fri, 30 Oct 2015 15:25:04 GMT

Is it possible to do a BUFFER load on a preceding load and if so where does the BUFFER prefix go?

buffer LOAD

[final field]

;

buffer LOAD

[some other field]

;

buffer LOAD

[some fields]

Resident

APreviousTable

;

Thanks

Oli

Re: Buffer on a preceding load

Tue, 03 Nov 2015 09:53:42 GMT

Hi again

Does anybody have a clue on this?

Thanks

Oli

Re: Buffer on a preceding load

Anonymous — Tue, 03 Nov 2015 09:55:38 GMT

Yes we can.

and path would be same, where you have stored your QVW.

Re: Buffer on a preceding load

tresB — Tue, 03 Nov 2015 10:09:37 GMT

Yes, it works with preceding load too. The way you showed should work fine. And if you are asking about location where it gets stored, check :

Re: Buffer on a preceding load

tresB — Tue, 03 Nov 2015 10:38:32 GMT

Well, perhaps you are asking this:

buffer LOAD

[final field]

;

buffer LOAD

[some other field]

;

buffer LOAD

[some fields]

Resident

APreviousTable

;

i.e. - you should place it at the top most of all preceding loads.

Re: Buffer on a preceding load

manojkulkarni — Tue, 03 Nov 2015 10:48:00 GMT

Use buffer only once at the top.

buffer LOAD

[final field]

;

LOAD

[some other field]

;

LOAD

[some fields]

Resident

APreviousTable

;

Re: Buffer on a preceding load

Tue, 03 Nov 2015 10:49:42 GMT

Hi Tresesco

Yes, that's exactly the bit of information I need.

Thanks

Oli