Qlik Community

Qlik Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Announcements
Attachments getting stuck in the virus scanner. The team is investigating.
Digital Support
Digital Support

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.

2 Comments
Luminary
Luminary

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

1,823 Views
Digital Support
Digital Support

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.

1,769 Views
Labels by Topic