Selecting data from an HTML file

You can load data from tables in HTML files, that is, tables that are encoded with the <TABLE> element.

The Select data from dialog opens when you click ± on a Folder or Web file connection in the data load editor. This is where you select the fields to load from the tables of the HTML file. You can select fields from several tables.

Selecting tables

Tables lists all tables in the HTML file.

If you want to select all fields of a table, do the following:

• Mark the checkbox next to the table name.

If you want to select specific fields of a table, do the following:

• Click on the table name (not in the checkbox).

  Fields will be updated with the available table content, and you can continue selecting fields.

Tables with all fields selected are indicated with a checkmark in the checkbox, while tables with some fields selected are indicated with a square in the checkbox and the number of selected fields to the right.

Selecting fields

Fields lists all fields available in the selected Table. You can Filter for fields in the list by typing part of the field name in the text box.

You may need to specify the following settings:

Field names:

• Embedded field names, if field names (field headers) are stored in the first line of data.
• No field names, if there are no field names.

Character set:

Do the following:

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

When you have selected the fields to include from the selected table, you can continue to select fields from other tables in the same file.

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.