Attaching data files and adding the data to the app

If you want to use data files from your computer, you can upload the data files and attach them to an app.

An attached file is only available in the app that it is attached to.

There is no connection to your original data file, so if you update the original file you need to refresh the attached file.

See: Managing security with section access

The maximum total size of files attached to the app, including image files uploaded to the media library, is 50 MB.

Attaching several data files quickly

The quickest and in most cases the easiest way to attach and add a set of data files to your app is to just drop the files in the app.

Do the following:

• Drop one or more data files in your app.

  The files are uploaded and attached to the app, and added to the data model.

When you attach files this way Qlik Sense will try to select the optimal settings for loading the data, for example, recognizing embedded field names, field delimiters or character set. If a table is added with settings that are not optimal you can correct the settings by opening the table in the table editor, and clicking Select data from source.

See: Editing a table

Attaching a single data file

You can attach data files one by one. This way you gain more control over file import settings, for example, embedded field names, field delimiters or character set used.

Do the following:

1. Click Add data in the Data manager or in the ¨ menu of any other app view.
2. Click Attach file.

3. Drop a data file, or click and select a file from your computer to load.

   If you try to attach a file with the same name as an already attached file, you get the option to replace the attached file with the new file.

   Information noteEach attached file needs to have an unique file name.

4. Select the tables and fields to load.

   See: Selecting data fields

5. Choose whether to continue to work on the data or to load the data into the app:

   • Click Prepare data to continue to add data sources, transform the data, and associate the tables in Data manager. Date and time fields will be created automatically. Data profiling is also performed to provide association recommendations. All fields that are common between tables are auto-qualified.

     Information note Tables are not associated on common field names automatically, and you need to associate all tables in the Associations view of Data manager.

   • Click Load data and finish to load the added data into the app and go to the sheet. This will also reload all existing data from data sources.

     Tables are associated on common field names automatically.

     Information noteDate and time fields will not be created if you use Load data and finish.

   If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.

Deleting an attached file

When you delete a table based on an attached file in the data manager, the table is deleted from the data model, but the attached data file remains in the app. You can delete the data file from the app permanently.

Do the following:

1. Click Add data in the Data manager or in the ¨ menu of any other view.
2. Click Attach file.
3. Delete the appropriate file.

The data file is now permanently deleted from the app.

Refreshing attached files

An attached file is only available in the app that it is attached to. There is no connection to your original data file, so if you updated the original file you need to refresh the attached file if you want the new data to be present in the app.

Do the following:

• Attach the file again, and confirm that you want to replace the attached file with the updated file. The updated file needs to have the same name as the attached file. You can refresh the file either by dropping it in the app, or using Add data and Attach file.

The content of the data files have now been refreshed.