Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can i use preceding load to fetch data from binary load?and explain
Use resident load instead Preceding load.
Hi
You can use Resident load and do some calculations.
Hi Mayli,
Please explain with example...
Thanks & regards
raja
Hi
Try like this
Binary comm_165702.qvw;
Load Person as TestName Resident Test;
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.
Not directly as the BINARY load has to be the first statement in the Script
Andy
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