Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Binary Load



I have a question:

I load data with the help of a binary load command. Is it possible to load just a special type
(one selling area, couple of products, etc.) of the whole binary data model, so
that the needed data model becomes smaller and the performance gets better.


1 Reply
Not applicable

Re: Binary Load

I don't think that you can set constraints to the binary load directly (like a where clause in a LOAD).

If the creation of a different source file or usage of qvd's instead of a binary load is not an option,

I can only think of doing data model changes after the binary load, maybe using resident loads with a where clause and dropping the original tables.

You might also consider using a Macro to select your subset of data and then reduce the data after reload.