Qlik Inline load

[Wlad_Masi]

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:

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:

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:

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.

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.

[mike_garcia]

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

[Wlad_Masi]

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.

[JShum]

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

[jochem_zw]

?? 

[JShum]

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

[RudyKostka]

[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 ',');

[E_Røse]

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. 

[AgustinaGonzalez]

Good morning! I would like to create a table that contains already created variables. When I use "Inline" it doesn't allow me. Is there any way?

For example:

//CHARGE DATA TABLE

LOAD
VRN,
Cliente,
Cuil,
Buque,
Chofer,
Camion,
"Clasificación vehiculo",
Acoplado,
"Clasificacion acoplado",
Entrada,
"Peso inicial",
"Usuario inicial",
Salida,
"Peso final",
"Usuario final",
"Peso Neto",
VGM,
Despacho,
"Numero remito",
"Almacen origen",
"Almacen destino",
"Mov origen",
"Mov destino",
FROM [lib://AttachedFiles/Viajes 2024.xlsx]
(ooxml, embedded labels, table is Sheet);

//CREATE VARIABLE

SET vHOLA= =Sum( {$< [Almacen destino] = {'BUQUE GENERICO'} >} [Peso Neto]);

SET vHOLA= =Sum( {$< [Almacen destino] = {'BARCAZA'} >} [Peso Neto]);

//CREATE INLINE TABLE

LOAD*INLINE

[Volumen de buques, Vol.de Barcazas,

vHOLA, vHOLA2 ---> It doesn't take the values ​​of the variables

]

Is there any way?

Thanks!!!!!!

[chriscammers]

You would have to use dollar sign expansion of your variables to include the value in the inline table like this.

//quoting may be needed to prevent any unexpected behaviour
//depending on the value of your variables
Load * Inline [
Field1, Field2
"$(vVar1)","$(vVar2)"
];

[AgustinaGonzalez]

I cant! coult it be because of the type of data? The variable is a numer. 

SET vHOLA =Sum( {$< [Almacen destino] = {'BUQUE GENERICO'} >} [Peso Neto]);

LOAD*INLINE
[Nro. , Enero
1,"$(vHOLA)"
2,"$(vHOLA)"
3,"$(vHOLA)"
];