Select and load data from an Amazon Comprehend 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 two columns, the row identifier and the text field that will contain the content to analyze. 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 Amazon Comprehend connection and click
. This opens the Select data wizard. -
Enter a Resident Table and Data Field, 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.
When selecting the table, you can select or deselect the columns to load.
-
A script is automatically generated based on the selections.
Click Insert script.
You will see the new script in the text editor.
-
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 Amazon Comprehend endpoints.