Selecting data from a KML file

You can load geographical data that is stored in KML format to use when creating a map visualization.

See: Map

Do the following:

1. Click ± on a Folder or Web file connection in the data load editor.
2. Select the KML file you want to load data from.

The Select data from dialog is displayed with Fields updated with preview data. This is where you select the fields to load from the tables of the file. You can select fields from several tables.

Selecting tables and fields

Tables lists all tables available to select. When you select a table, Fields is updated with the available fields. By default, all data is selected.

• If you want to exclude a table or a field, mark the checkbox next to the table or field name.

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 to be 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 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 when you select something else.

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.