Creating Resident Table from Binary Load

[#1]

Hi,

Please help me on creating multiple Resident tables from Binary Load.

Thanks

Raju

[#2]

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.

[jagan]

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.

[#4]

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.

[#5]

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.