There is yet another way of adding a table to a data model, and it's one that is especially useful for small tables that do not necessarily reside in a database. For example, those that contain a custom description of an entity. With an Inline table, the data is entered directly into the Edit Script window. The process to input an Inline table is outlined here.
From the Edit Script window, go to the Insert menu and select Load Statement | Load Inline. The Inline Data Wizard will appear as shown in the screenshot below:
The window is similar to a spreadsheet, with rows and columns.
To enter heading labels, double-click on theheader cell.
We can start typing data into the cells, and after we are finished entering the content of the table, we can click on OK.
Importing document data to the Inline table
It is possible to enter, within the Inline wizard, a list of values contained in a field that is already stored in RAM. This is done via the Import Document Data wizard. To bring up this wizard, go to the Tools menu from the Inline Data wizard and select Document Data..
The resulting script for our input table would be similar to the following:
LOAD * INLINE [
The advantage of this approach is that you will not need to maintain a separate table (whether on a database or a table file) when dealing with a small table of this sort. Keep in mind that the values will be hardcoded in the script. Whenever you need to change them, it can only be changed in the script.
Qlik View Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|PL/SQL Interview Questions||MSBI Interview Questions|
|VBA For Excel Interview Questions||SAP BO Interview Questions|
|SQL Database Interview Questions||Qlik View Interview Questions|
|R Programming language Interview Questions||Pentaho Interview Questions|
|Advanced SAS Interview Questions|
Qlik View Tutorial
Seeing Is Believing
Data Modeling Best Practices
Basic Data Transformation
Set Analysis And Point In Time Reporting
Advanced Data Transformation
More On Visual Design And User Experience
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.