Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is INLINE?
what does it do??
Heres a snippet from help page (Load ‒ QlikView)
chk dis
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
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!!
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 ];
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
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.