Insert data into a table in the app using an automation.
I have an automation that retrieves a list of data from an app, which I want to save in a "temporary" table in Qlik in order to update a column in a table within the same app. In other words, I select a list of contacts, then through a button, I trigger an automation that updates the status of those contacts to "processed".
Is it possible to create this table using Qlik Sense Automation to allow me to update the status of these contacts?
When you talk about a "temporary table" in Qlik Sense Automation for updating a column, you're not creating a persistent table in a database that your Qlik Sense app directly queries and updates. Instead, you'll be: Dog Translator Apps
Retrieving the selected data: Getting the list of contact IDs from your Qlik Sense app. Using a variable of type "Table" in Automation: Qlik Sense Automations have a "Variable" block that can be configured to hold data in various formats, including "Table". This acts as your temporary in-memory structure within the automation flow. Performing the update logic: In the automation, you'll process this "temporary table" (the variable) to prepare the data for the update. Writing back the updated data: You'll use an appropriate connector to write the updated "processed" status back to your source system (e.g., a database, an Excel file, a Google Sheet, etc.). Qlik Sense itself doesn't allow direct "write-back" to its internal data model in the same way a database does. Reloading the Qlik Sense app: After the external source is updated.
When you talk about a "temporary table" in Qlik Sense Automation for updating a column, you're not creating a persistent table in a database that your Qlik Sense app directly queries and updates. Instead, you'll be: Dog Translator Apps
Retrieving the selected data: Getting the list of contact IDs from your Qlik Sense app. Using a variable of type "Table" in Automation: Qlik Sense Automations have a "Variable" block that can be configured to hold data in various formats, including "Table". This acts as your temporary in-memory structure within the automation flow. Performing the update logic: In the automation, you'll process this "temporary table" (the variable) to prepare the data for the update. Writing back the updated data: You'll use an appropriate connector to write the updated "processed" status back to your source system (e.g., a database, an Excel file, a Google Sheet, etc.). Qlik Sense itself doesn't allow direct "write-back" to its internal data model in the same way a database does. Reloading the Qlik Sense app: After the external source is updated.
