topic Re: Creating Resident Table from Binary Load in QlikView

Creating Resident Table from Binary Load

Tue, 24 Dec 2013 06:36:13 GMT

Hi,

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

Thanks

Raju

Tue, 24 Dec 2013 06:46:13 GMT

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 — Tue, 24 Dec 2013 06:46:16 GMT

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.

Tue, 24 Dec 2013 18:02:06 GMT

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.

Wed, 25 Dec 2013 03:58:32 GMT

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.