topic Re: can i use preceding load to fetch data from binary load?and explain in QlikView

can i use preceding load to fetch data from binary load?and explain

Mon, 03 Aug 2015 05:57:09 GMT

can i use preceding load to fetch data from binary load?and explain

Re: can i use preceding load to fetch data from binary load?and explain

qlikmsg4u — Mon, 03 Aug 2015 06:13:16 GMT

Use resident load instead Preceding load.

Re: can i use preceding load to fetch data from binary load?and explain

MayilVahanan — Mon, 03 Aug 2015 06:14:40 GMT

You can use Resident load and do some calculations.

Re: can i use preceding load to fetch data from binary load?and explain

Mon, 03 Aug 2015 06:22:54 GMT

Hi Mayli,

Please explain with example...

Thanks & regards

raja

Re: can i use preceding load to fetch data from binary load?and explain

MayilVahanan — Mon, 03 Aug 2015 06:54:33 GMT

Try like this

Binary comm_165702.qvw;

Load Person as TestName Resident Test;

Re: can i use preceding load to fetch data from binary load?and explain

jagan — Mon, 03 Aug 2015 07:00:57 GMT

Hi,

Precedent Load is a different concept, you have to use Resident load for this.

Example:

Binary FileName.qvw;

TableName_New:

Load *

Resident TableNameRequired;

This is the pattern to the read the data from Binary load.

Hope this helps you.

Regards,

Jagan.

Re: can i use preceding load to fetch data from binary load?and explain

awhitfield — Mon, 03 Aug 2015 13:50:05 GMT

Not directly as the BINARY load has to be the first statement in the Script

Andy

Re: can i use preceding load to fetch data from binary load?and explain

puttemans — Mon, 03 Aug 2015 14:02:07 GMT

Hi Raja,

A binary load allows you to load a complete existing model into a new qv-application. In order to do so, the binary load needs to sit at the very first line of your new QV-application. So first tab, first line, and start with 'Binary path to your existing application.

A preceding load is a 'bypass' in your script. Instead of re-loading the same table with a new name, you can use preceding load. This is similar to a load script, but you do not mention the source, and you end with ';'. So it looks like this :

400:

LOAD *,

a+b as C;

LOAD

a+d as b

FROM....

As you'll see, in the first load, the 'preceding' load, I create b out of the variables, in the scriptlines in-between the table name (400) and the first load, I define C. I could have done this also with a table nr 500, but this way is easier. Always make sure to end with ';' if you use a preceding load.

I hope this is clear to you, and that it is clear as well that both load-types are quite different.

Kind regards,

Johan