In QlikView, optimization of Load data plays a crucial role, and it is applicable at any phase of the QlikView Application Development Cycle. Among many methods, "loading data from existing QVD(QlikView Document)" is the best method for optimizing load data. This method is called a Binary Load.

What is Binary Load

Binary Load is used to replicate or copy the data model present in an already available QlikView document into another QVD(QlikView Document) without using the primary data source. When the data model is replicated into another QVD(QlikView Document), it is altered further. 

Uses of Binary Load

The two primary uses of Binary Load are as follows:

  • Sharing a Data Model
  • Loading Data in Incremental Build

Sharing a Data Model

The "binary" statement is used to load the data from the QlikView document. It does not layout variables or data. We should load only data through a "binary" statement from the documents in an advanced data model. We should not load the data from the document that includes synthetic keys.

Syntax:

binary [path1] filename1

Parameters

The binary statement will have the following parameters:

Filename: This parameter is used to take a filename as input and file extension ".qvw" also.

Path: This parameter is used to take the path of the ".qvw" file.

Subscribe to our youtube channel to get new updates..!

Related Page: Creating QVDs Using QlikView Publisher

Loading Data In Incremental Load

When Conducting Incremental Build, we will load data from different sources. Data loading is quick when data is in a small volume, but when data is in large volume, it takes a long time. Binary Load will solve this problem through the following process:

Step1: The process starts with a regular incremental build utilizing a QlikView Document(QVD) to save the transaction table and a reporting interface.

Step2: A new QVW is created for loading the content of the QlikView Document(QVD), and it includes the document in its history. The QVD stores only data that has been inserted since the creation of new QVW.

Step3: The reporting interface is altered to the latest QVW to retrieve the history data before the concatenation of QVD.

Frequently Asked QlikView Interview Questions & Answers

Advantages of Binary Load

  1. It is used for sharing the available data model of a QVD with another QVD(QlikView Document).

  2. Binary Load is the quickest method for loading data into QVD(QlikView Document).

  3. It assists in developing sophisticated incremental load scenarios.

  4. It reduces designing time and accelerates the reload process through the avoidance of additional data load for creating a new model.

Related Page: Process Of Incremental Load In QVD QlikView

Implementing Binary Load in QlikView

Let us see how to implement Binary Load in QlikView. 

1. First, open the script editor in the QVD(QlikView Document) where we want to load binary. Open the "QlikViewFile" button located at the base(bottom) of the script editor.

2. Choose the QlikViewWindow(QVW) file you want to load as a binary. After choosing, press open.

In the below screenshot we can see the selection of the ".QVW” file.

Binary Load in QlikView - ".QVW” file

3. The "Binary" statement is written at the top of the script. We can load the binary into the script that has loaded already existing files.

In the below screenshot, we can see the Binary statement at the top of the script.

Binary Load in QlikView - Binary statement at the top of the script.

 

4. After that save the script and press "OK" to close the script editor. The QVW file is loaded into the document with other files.   

Binary Load in QlikView - QlikView Editing Code

5. In the below screenshot, we can see newly included data files with the available files.

Binary Load in QlikView - Data Flies table

Conclusion

In this article, we have discussed the Binary statement to optimize the load data. Binary statement loads data from a ".QVW" file to optimize. We can use Binary Load for building incremental scenarios. We implemented Binary Load by choosing an existing ".QVW" file.

Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!