Adding data from uploaded data files

You can upload data files to your Qlik Sense Cloud and then load the data into your app.

Import your data files

Before you can add data, you need to import the data files to Qlik Sense Cloud.

Note: The files that you upload to your personal cloud cannot be used in a group workspace, and vice versa.

Do the following:

  1. Click Import data in your workspace.
  2. Upload a data file.

Load data into an app

You can select data from connections that have already been defined by you. In Qlik Sense Cloud, this can be a folder containing data files.

Warning:

Do not add a table in Data manager that has already been added as a scripted table with the same name and same columns in Data load editor.

Do the following:

  1. Open an app.
  2. Open the Data manager and then click ú. You can also click Add data in the ¨ menu.
  3. Click Data files.
  4. Choose a file to add the data.
  5. Select the tables and fields to load.

    For more information, see Selecting data fields.

  6. Click Add data to open the data in the Associations view of the data manager. This allows you to continue to add data sources, transform the data, and associate the tables in Data manager.

    Data profiling is enabled by default when you click Add data. Data profiling does the following:

    • Recommends data associations.
    • Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
    • Maps date and time fields to autoCalendar.

    Tables are not associated on common field names automatically. You can associate tables in the Associations view.

    Tip: If you want to load the data directly into your app, click ¥ and then disable data profiling. This will also reload all existing data from data sources when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created.

    For more information, see Managing data associations.

  7. Click Load data when you are done preparing the data. If serious problems are detected, you need to resolve the problems in Data manager before you can load data into the app.

    For more information, see Troubleshooting - Loading data.

Import an updated data file

To update data in an app, you can import an updated data file of the same name, and then reload the data into your app.

Do the following:

  1. Click Import data in your workspace.
  2. Upload a data file. The new data file overwrites the file in Data files.

Reload data into an app

Do the following:

  1. Open the app in your workspace.
  2. Select Add data from the toolbar drop-down list, and then click Data files.
  3. Choose the updated file with the same name as your original file.
  4. Click Add data.
    The Associations view of the Data manager opens.
  5. Select the table with updated data, and then click b. The data is updated in the Data manager.
  6. Click Load data to load the data in the app.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?