Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Buffer on a preceding load

Hi

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Buffer on a preceding load

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.

View solution in original post

6 Replies
Highlighted
Not applicable

Re: Buffer on a preceding load

Hi again

Does anybody have a clue on this?

Thanks

Oli

Highlighted
balrajahlawat
Esteemed Contributor

Re: Buffer on a preceding load

Yes we can.

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

Highlighted
MVP
MVP

Re: Buffer on a preceding load

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 :

Untitled.png

Highlighted
MVP
MVP

Re: Buffer on a preceding load

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.

View solution in original post

Highlighted
Partner
Partner

Re: Buffer on a preceding load

Use buffer only once at the top.


buffer LOAD   

     *,

     [final field]

;

LOAD

     *,

     [some other field]

;

LOAD

     [some fields]

Resident

     APreviousTable

;

Highlighted
Not applicable

Re: Buffer on a preceding load

Hi Tresesco

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

Thanks

Oli