Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Wlad_Masi
Employee
Employee

Inline load is a type of data load that can be used when you do not have a data source. The data can be entered manually or by using the wizard within QlikView or Qlik Sense.

Here are a couple of key things to remember:

  • Data entered through an inline clause must be enclosed by square brackets [ ]
  • The columns of the table are defined in the first line of the inline load statement, separated by comas.
  • A semi colon (;) is required after the closing square bracket


Here is an example of a simple table using inline load:

Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31, Team Lead

2, Paul, 22, Technical Support Engineer

3, Mark, 40, Customer Support Engineer

4, Janne, 27, IT Specialist

];

 

In the example inline load above, the columns for the table are:

  • ID
  • Name
  • Age
  • Title


The values starting with 1, are all data values that will populate the table. After loading the data, and looking at the data model, it will look like a normal table:

Wlad_Masi_0-1587737439846.png

 

As with any other dataset, two inline load tables can be created and be connected as can be seen below. You can also connect your inline table to an already existing table:

Wlad_Masi_1-1587737439848.png



Inline load using the QlikView wizard:

You can accomplish the same result using the QlikView Inline load wizard.
In the edit script window, go to Insert > Load Statement > Load Inline. A window with a structure of a table will appear. Select the top cell indicated by F1 and change its value to the name of your first column. Repeat for the other columns of your inline table. Insert the data to create the table.  At the end, your table should look like this:

Wlad_Masi_2-1587737439854.png

 

 

Inline load using the Qlik Sense wizard:

 In the Data Manager, select the ‘Manual Entry’ option located at the top left corner of the screen.

Add the table name and double click on Field_1 cell to insert your first column name. Repeat this for the other columns. After naming all the columns, you should have something like in the image below.
Note that at the bottom right you can see the column count = 4 and number of rows = 0. If you Insert data, you see that the number of rows is no longer 0.

Wlad_Masi_3-1587737439857.png

 

For more detail information on using the Qlik Sense Wizard, please see the following resources:

Manual Entry - Qlik Sense
Inline load Delimiter


Please give this post a like if you found it helpful! Also please let us know if you have any questions or leave your feedback in the comments.

7 Comments
mike_garcia
Luminary Alumni
Luminary Alumni

Thanks for sharing this. This feature is quite handy.

I do miss the "Tools" menu we have in the QlikView Inline Wizard, but not in Qlik Sense, that allows you to import values from an existing field in the Data Model directly into the Inline Editor and avoid typos.

To avoid confusion, the Qlik Sense "Manual Entry" Wizard is located on the Data Manager, not in the Data Load Editor.

Miguel

32,047 Views
Wlad_Masi
Employee
Employee

Thank you for your feedback @mike_garcia.
Indeed this option in QlikView is good and it can be a good topic for a feature request that can be logged in our ideas board here in community.

I also would like to thank you for correcting me on the Data Load Editor ... You are correct it is Data Manager.
I edited the blog post.

31,993 Views
JShum
Contributor II
Contributor II

How do you handle an inline load if you have a [ the value you are trying to load?

3,215 Views
jochem_zw
Partner Ambassador
Partner Ambassador

?? 

jochem_zw_0-1700678288594.png

 

3,175 Views
JShum
Contributor II
Contributor II

Try

LOAD * INLINE [
1, []
2, TEST
] ;

It doesn't like that character I don't think as it thinks it's the end of the inline command and the delimiter specification will not handle it

3,134 Views
RudyKostka
Partner - Contributor II
Partner - Contributor II
[Table]:
LOAD * INLINE [
code,char
1,[
2,]]
3,f
](delimiter is ',');

//used special characters, which are subsequently replaced via Replace() with the required characters
Table2:
LOAD code, Replace(Replace(char2,'Đ','['),'đ',']') as char2 INLINE [
code, char2
1, Đ
2, đ
3, f
](delimiter is ',');

RudyKostka_0-1700681234950.png

 

3,095 Views
E_Røse
Creator II
Creator II

 

LOAD * INLINE "column1, column2

1, [

2, TEST

" ;

@JShum use " 

as the start/en of your table instead of [ ]. Also, the (comment as '#') is a very usefull feature after the last ", so that you can comment out lines. 

3,021 Views