topic Re: INLINE in QlikView

INLINE

Wed, 25 Nov 2020 16:16:04 GMT

what is INLINE?

what does it do??

Re: INLINE

sunny_talwar — Wed, 20 Apr 2016 21:00:51 GMT

Heres a snippet from help page (Load ‒ QlikView)

Re: INLINE

Chanty4u — Thu, 21 Apr 2016 04:54:20 GMT

chk dis

Types of Load into QlikView

Re: INLINE

vikasmahajan — Thu, 21 Apr 2016 04:57:32 GMT

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

Re: INLINE

avinashelite — Thu, 21 Apr 2016 05:41:06 GMT

for more explanation check this thread

Inline table

Load Inline | Qlik Community

Re: INLINE

Anonymous — Thu, 21 Apr 2016 06:19:46 GMT

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!!

Re: INLINE

Anonymous — Thu, 21 Apr 2016 06:23:12 GMT

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 ];

Re: INLINE

Peter_Cammaert — Thu, 21 Apr 2016 07:53:59 GMT

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

Re: INLINE

prabhas277 — Thu, 21 Apr 2016 11:29:44 GMT

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.