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 Gerenciador de dados
Faça o seguinte:
-
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 Gerenciador de dados.
Ao importar um arquivo de conjunto de dados para um aplicativo ou espaço do Qlik Sense com Gerenciador de dados (arrastar e soltar ou outros uploads diretos), o número máximo de campos que podem ser carregados é 5000.
Next steps
Your selected data is now available in Gerenciador de dados. You can continue working on your tables in Gerenciador de dados, 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 Gerenciando associações de dados
-
To edit your tables, adding calculated fields or using the data profiling cards to transform your data, see Editando uma tabela.
-
To concatenate related tables, see Concatenando tabelas no Gerenciador de dados.
-
To join tables together, see Unindo tabelas no Gerenciador de dados
Loading data from the data catalog in Editor de carregamento de dados
Faça o seguinte:
-
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.