Selecting data from a QVD or QVX file

You can load data from QVD files created by Qlik Sense and QVX files created by a custom connector. When you have selected which fields to load, you can insert the script code required to load the fields into the script.

To select data, do the following:

1. Click ± on a Folder data connection in the data load editor.
2. Select a QVD or QVX file from the drop-down list of available files in the folder and click Select.

Select data from is displayed with Fields updated with preview data.

Selecting fields

Fields lists all fields available to select. You can either:

• Select the fields to include by marking the checkbox next to each field name.
• Click Select all fields

Renaming fields

You can rename fields. This is particularly useful in the following two cases:

• If you load two files containing a field with the same name, they will by default be linked and treated as one field in Qlik Sense. If you want to load them as separate fields, rename the fields so that they are different.
• If you load two files containing a field that should be read as one field, but has different names in the respective files, you can rename them (in either file) to have identical names to load them as one field.

Do the following:

• Click on the field header you want to rename, type the new name and press Enter.

The field is renamed, and the script preview is updated.

Previewing the script

The statements that will be inserted are displayed in the script preview, which you can choose to hide by clicking Preview script.

Inserting the script

When you have finished selecting fields and want to generate your LOAD statements in the script, do the following:

• Click Insert script.

The Select data from window is closed, and the LOAD statements are inserted in the script in accordance with your selections.