Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help me on creating multiple Resident tables from Binary Load.
Thanks
Raju
Attached sample binary load and resident of load for your reference.
1. Use the binary load very first statemt of ur script
Binary t.qvw;
2. See the table viewer for binary loaded tables.
3. Resident all te tables which u wanted create as separate tables.
Hi,
You can use existing tables in Binary Load qlikview file like this
LOAD
*
RESIDENT TableNameInBinaryLoadFile;
Hope this is what you need, if not comeup with an example.
Regards,
Jagan.
i am trying to do below example
Table1:
Binary
I know above example is error but my requirement is create a table from Binary Load.
Please help me on other alternates.
Hi Raju,
Above script (thanks Jagan) working it’s fine,
For ex,
Binary
Then you create separate resident table,
Trades:
LOAD * Resident [Trades];
In QV document having number of tables available, you cannot load all tables and data into one table.
You can separately, load one by one, whatever table you need.