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.
binary [path1] filename1
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.
Advantages of Binary Load
It is used for sharing the available data model of a QVD with another QVD(QlikView Document).
Binary Load is the quickest method for loading data into QVD(QlikView Document).
It assists in developing sophisticated incremental load scenarios.
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.
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.
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.
5. In the below screenshot, we can see newly included data files with the available files.
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.