Select and load data from an Azure ML connection
Once you have created a connection, you can select data and load it into a Qlik Sense app or script. You load data in Data load editor or Script.
Before a connection can be used, the app requires at least a source data table with a unique identifier and input fields which will contain the content to send to the models for machine learning problems and tasks. Make a note of the Table and Field name, you will need these in the Select dialog next.
Do the following:
-
Open Data load editor or Script.
-
In the Data sources panel on the right-hand side of the page, navigate to the saved connection and click
. This opens the Select data wizard. -
Enter a Resident Table to be sent to the machine learning endpoints.
The Resident Table should be the name of the resident table with source data that you have loaded into your app. You will find the resident table name in the Data model viewer.
-
The available return table will automatically appear under Tables.
The name of the return table is the one that has been configured in the connection.
-
Select Dynamically Load All Fields if you wish to load all fields returned from the model into your app and if you have created the Azure ML connection with the configuration to Load all available fields.
-
Select the column names to be loaded into the app if the connection was created without Load all available fields.
-
-
A script is automatically generated based on the selections.
Click Insert script.
-
The new script will be seen in the text editor but needs additional editing.
Complete the script by specifying only the fields that the Azure ML model expects. All fields must be available in the resident table.
-
Reload the app.
When a reload of an app occurs it will first expect to load the source data as a resident table and use this as input to the request made to Azure ML endpoints.