Adding and managing data with the Data manager

The Data manager is where you add and manage data from your own data sources, or from Qlik DataMarket, so that you can use it in your app. Data tables contain all the tables you have loaded using Add data. Each table is displayed with the table name, the number of data fields, and the name of the data source.

You can preview the data if you click on a table. You can also edit the data table selection or delete the data table.

When you add data tables in the Data manager, data load script code is generated. You can view the script code in the Auto-generated section of the data load editor. You can also choose to unlock and edit the generated script code, but if you do, the data tables will no longer be managed in the Data manager.

See: Unlocking an auto-generated section

Adding a new data table

You can quickly add a data table into your app, by clicking Add data in Data manager or in the ¨ menu.

You can add data from the following data-source types:

• Connections

  Select from data connections that have been defined by you or an administrator, and folders that you previously have selected data from.

• Connect my data

  Select from a new data source, such as ODBC or OLE DB databases, data files, web files or custom connectors.

• Qlik DataMarket

  Select from normalized data from public and commercial databases.

• Attach file

  Upload a data file from your computer and attach it to your app.

See: Adding data from files and databases

Editing a data table

You can edit all the data tables that you have added with Add data. You can add, remove, or rename fields from the data table.

Do the following:

1. Click @ on the data table you want to edit.
2. Edit the selection of data fields.
3. Click Finish to save the data field selection.

See: Selecting data fields from your data source

Deleting a data table

Do the following:

• Click Ö on the data table you want to delete.

Reloading all data

Do the following:

• Click ° to reload all data in the app.

Concatenated tables

If the field names and the number of fields of two or more loaded tables are exactly the same, Qlik Sense will automatically concatenate the content of the different statements into one table.

Concatenated tables are shown with a dotted frame.

See: Concatenating tables

Synthetic key tables

When two or more data tables have two or more fields in common, this implies a composite key relationship. Qlik Sense handles this by creating synthetic keys automatically. These keys are anonymous fields that represent all occurring combinations of the composite key.

See: Synthetic keys

If synthetic key tables have been created as a result of adding data, you can recognize them in Data tables as the name starts with $. A synthetic key table contains the synthetic key and the data fields that form the relationship.

You can't edit a synthetic key tables as they are created automatically when Qlik Sense loads data.