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

[#1]

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

[qlikmsg4u]

Use resident load instead Preceding load.

[MayilVahanan]

Hi

You can use Resident load and do some calculations.

[#4]

Hi Mayli,

   Please explain with example...

Thanks & regards

raja

[MayilVahanan]

Hi

Try like this

Binary comm_165702.qvw;

Load Person as TestName Resident Test;

[jagan]

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.

[awhitfield]

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

Andy

[puttemans]

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,

          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