Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Resident Table from Binary Load

Hi,

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

Thanks

Raju

4 Replies
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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.

Not applicable
Author

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.