topic Re: Binary Load in QlikView

Binary Load

deepali_more — Tue, 23 Feb 2016 05:36:45 GMT

Hi Friends,

Can you please let me know what all are the things that also gets loaded while doing Binary Load in Qlikview?

will section accesses also gets transfered? Do variables also gets transferred while doing Binary laod?please let me know asap

Thanks a lot!!

Re: Binary Load

tresB — Tue, 23 Feb 2016 07:35:36 GMT

Binary load brings only data and no layout.

Variables - No. Section Access - Yes.

Re: Binary Load

Chanty4u — Tue, 23 Feb 2016 07:35:54 GMT

hi,

chk dis

What are the restrictions of Binary Load?

Binary load with variables

Binary load

Re: Binary Load

Tue, 23 Feb 2016 07:38:57 GMT

Hi Deepa,

The binary statement is used for loading the data from another QlikView document.

Section access data will be included but it does not load the layout information or variables.

You can get more information in the 'Help' of QlikView

Regards,

Rohan

Re: Binary Load

deepali_more — Tue, 23 Feb 2016 07:39:19 GMT

Useful, but may i know the reason..like proper elaboration on this...why variables dont get loaded and section accesses do.

Thanks tresesco

Re: Binary Load

Anonymous — Tue, 23 Feb 2016 07:46:08 GMT

Agreed with Tresescp, Binary Load will fetch:

Data Model , Section Access: Yes

Variables, Layout: No

Re: Binary Load

deepali_more — Tue, 23 Feb 2016 07:52:03 GMT

Thanks Rohan

Re: Binary Load

jagan — Tue, 23 Feb 2016 08:19:06 GMT

HI,

Binary Load brings all data and Section access (if any), but it will not load Charts and Variables.

Hope this helps you.

Regards,

Jagan.

Re: Binary Load

tresB — Tue, 23 Feb 2016 08:23:31 GMT

This is by-design. And my reasoning would be like - binary load is meant for copying solely data that come from symbol tables and the data tables. QlikView transform the data loaded into two table types: one data table and several symbol tables. Section access being data source, probably gets stored similarly as well (however, the table can't be referenced in the script later on). Variables, layouts are not part of data (internal tables) - hence, they are not copied in binary load. For better understanding, you may refer the great blog post: Symbol Tables and Bit-Stuffed Pointers by Henric. hic‌

Hope this helps.