Script syntax

In a script, the name of the data source, the names of the tables, and the names of the fields included in the logic are defined. Furthermore, the fields in the access rights definition are defined in the script. A script consists of a number of statements that are executed consecutively.

The Qlik Sense command line syntax and script syntax are described in a notation called Backus-Naur Formalism, or BNF code.

What is Backus-Naur formalism?

The first lines of code are already generated when a new Qlik Sense file is created. The default values of these number interpretation variables are derived from the regional settings of the OS.

Working with variables in the data load editor

Number interpretation variables

The script consists of a number of script statements and keywords that are executed consecutively. All script statements must end with a semicolon, ";".

Script statements and keywords

You can use expressions and functions in the LOAD-statements to transform the data that has been loaded.

Script expressions

For a table file with commas, tabs or semicolons as delimiters, a LOAD-statement may be used. By default a LOAD-statement will load all fields of the file.

General databases can be accessed through ODBC or OLE DBdatabase connectors. . Here standard SQL statements are used. The SQL syntax accepted differs between different ODBC drivers.

Additionally, you can access other data sources using custom connectors.

Connecting to data sources