Loading data from the data catalog
You can load data into your app from existing datasets to which you have access with the data catalog.
Loading data from the data catalog in Datahanteraren
Gör följande:
-
Open an app.
-
Open Data manager.
-
Click Add data > Data catalog. You can also click Data catalog in .
-
Select the data you want to load.
-
If you want to load all the data in a dataset, select the checkbox in that dataset's row.
-
If you want to load certain tables or fields from a dataset, click the dataset's name. Select the fields from the tables you want to load. Click Back to add more data or click Next.
-
-
In Summary, review the data you are adding to your app and click Load into app.
The tables are added to Datahanteraren.
När du importerar en datauppsättningsfil till en Qlik Sense app eller ett utrymme med Datahanteraren (dra och släpp eller andra direkta uppladdningar) så kan du ladda högst 5 000 fält.
Next steps
Your selected data is now available in Datahanteraren. You can continue working on your tables in Datahanteraren, making associations or editing your tables using the data profiling options. When you are ready to load the data into your app, click Load data.
Some additional steps you may wish to do before loading data:
-
To associate your tables, see Hantera dataassociationer
-
To edit your tables, adding calculated fields or using the data profiling cards to transform your data, see Redigera en tabell.
-
To concatenate related tables, see Konkatenera tabeller i Datahanteraren.
-
To join tables together, see Koppla ihop tabeller i Datahanteraren
Loading data from the data catalog in Skriptredigeraren
Gör följande:
-
Open an app.
-
Open Data load editor.
-
Under Add data, click Add from data catalog.
-
Select the data you want to load.
-
If you want to load all the data in a dataset, select the checkbox in that dataset's row.
-
If you want to load certain tables or fields from a dataset, click the dataset's name. Select the fields from the tables you want to load. Click Back to add more data or click Next.
-
-
In Summary, review the data you are adding to your app and click Insert script.
The tables are added to the load script.
Limitations
Data catalog has the following limitations:
-
When selecting a QVD created from an Amazon S3 bucket, data catalog always uses the first connection in the list if there are multiple connections.