Qlik Core Load Script Examples

As of 1 July 2020, Qlik Core is no longer available to new customers. No further maintenance will be done in this repository.

This repository contains examples load scripts used to load data in different ways into Qlik Associative Engine.

The examples provide a good starting point to explore for anyone with the need to write load scripts specific to their use and applications built with Qlik Core.

Running the examples

Docker and Node.js must be installed on the machine running the examples. The Qlik Core EULA needs to be accepted by setting the ACCEPT_EULA environment variable to yes.

All examples run towards a single instance of Qlik Associative Engine. Change the value of ACCEPT_EULA accordingly and start it with:

ACCEPT_EULA=<yes/no> docker-compose up -d

This mounts all necessary sample data into the engine container.

Next, install dependencies:

npm install

You can now run each script example by providing it as an argument to npm start. Note that you should omit the scripts/ folder and only type out the filename. For example, to run the load script named `csv-file.qvs', run:

npm start csv-file.qvs

This should print the table content loaded into Qlik Associative Engine to the console.

List of examples

The table below lists all load script examples and what main topics of writing load script they cover. All load script examples are located in the scripts/ folder.

Load script	Key topics
csv-file.qvs	Loading data from a CSV file.
xlsx-file.qvs	Loading data from an Excel file.
inline-table.qvs	Loading an inline table.
subset-of-fields.qvs	Loading a subset of fields.
rename-fields.qvs	Renaming fields.
field-functions.qvs	Change fields values with string functions.
formating-functions.qvs	Format input and display formats of date fields.
split-field.qvs	Splitting a field into several fields. Using the subfield function.
compound-field.qvs	Creating a compound field from other fields. String concatenation.
resident-load.qvs	Loading data from previously loaded table.
preceding-calc-field.qvs	Using preceding LOAD to calculate a new field in single pass.
preceding-reuse-calc.qvs	Using preceding LOAD to avoid duplicate calculations. Usage of the AUTOGENERATE statement and the RecNo function.
concat-tables-auto.qvs	Automatic concatenation into one table.
concat-tables-forced.qvs	Forced concatenation into one table.
crosstable.qvs	Turn a wide table into a tall table.
webpage.qvs	Load data from a html source