Loading data from files

Qlik Sense can read data from files in a variety of formats:

• Text files, where data in fields is separated by delimiters such as commas, tabs or semicolons (comma-separated variable (CSV) files).
• HTML tables.
• Excel files (except password protected Excel files).
• XML files.
• Qlik native QVD and QVX files.
• Fixed record length files.
• DIF files (Data Interchange Format). DIF files can only be loaded with the data load editor).

In most cases, the first line in the file holds the field names.

There are several ways to load data from files:

• Add data

  See: Adding data from files and databases

• Selecting data from a data connection
• Loading data from a file by writing script code

Selecting data from a data connection

Instead of typing the statements manually in the data load editor, you can use the Select data dialog to select data to load. Do the following:

1. Open the data load editor.
2. Create a Folder data connection, if you don't have one already. The data connection should point to the directory containing the data file you want to load.
3. Click ± on the data connection to open the data selection dialog.

Now you can select data from the file and insert the script code required to load the data.

See: Select data to load

See: Folder data connections

Loading data from a file by writing script code

Files are loaded using a LOAD statement in the script. LOAD statements can include the full set of script expressions.

To read in data from another Qlik Sense app, you can use a Binary statement.

Example:  

directory c:\databases\common;

LOAD * from TABLE1.CSV (ansi, txt, delimiter is ',', embedded labels);

LOAD fieldx, fieldy from TABLE2.CSV (ansi, txt, delimiter is ',', embedded labels);