Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

INLINE

what is INLINE?

what does it do??

8 Replies
sunny_talwar

Heres a snippet from help page (Load ‒ QlikView)

Capture.PNG

Chanty4u
MVP
MVP

vikasmahajan

using Inline load you can load inputs means there is no need of any data source  , any input data you can provide through inline

Syntax

Table Name:

  Load  *  inline [  Field1,Field2 , .....

                              Data1,Data2 ...

                               Data1.1, Data2.2

      ];

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
avinashelite

for more explanation check this thread

Inline table

Load Inline | Qlik Community

Anonymous
Not applicable
Author

Hi David,

Inline Load helps us in loading the tables which are not in the Databases or Flat files.  It is useful whenever the data is very less (i.e., less number of records). For example, those that contains a custom description of an entity, Age Groups and there Sort Order, Salary Grouping, Customer Regions, Month Names, Quarter Names etc. With an Inline table, the data is entered directly into the Edit Script window.

Hope it helps!!

Anonymous
Not applicable
Author

Example:

LOAD * INLINE [

MonthNo., Month    

1, January   

2, February   

3, March   

4, April   

5, May   

6, June   

7, July   

8, August   

9, September   

10, October   

11, November   

12, December ]; 

Peter_Cammaert
Partner - Champion III
Partner - Champion III

INLINE tells the LOAD statement to load data from the script code instead of from an external or other source  To separate the script data from the the script code, the data block is enclosed in delimiters (usually square brackets).

Compare it to reading from a CSV file, except that the CSV data is embedded in your script instead of in an external file.

Keepi in mind: only useful for small data sets that don't change too often (or better: never change) and for testing purposes. You'll see many xcommunity example documents that include their data in INLINE blocks and thereby avoid having to add external files that may get lost.

Peter

prabhas277
Creator
Creator

Hi David,

Creating our own table in Qlikview where we do not have database. We can load data manually into qlikview. It is mainly used to create data islands, flags and mapping tables.