Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This article describes the templates available in Qlik Application Automation which allow you to synchronize data from a Qlik Sense straight table to Microsoft Excel.
We have two templates currently available
Let's discuss the automation configured in Qlik Application Automation to copy data from the Qlik Sense straight table to Microsoft Excel.
Similar to the 'Copy and update data from a Qlik Sense straight table to an Excel sheet' template, we'll use a Qlik Sense straight table as the source data set.
The main difference between these two templates is that in the 'Copy data from a Qlik Sense straight table to an Excel sheet' template we don't sync data to an already existing Microsoft Excel worksheet or table, instead, we will create a new worksheet and table within this worksheet with the required headers.
Please check out the attached JSON file containing the above automation.
Follow the steps provided in this article Upload Automation Workspace to import the automation from the copy-data-qlik-sense-excel.json file that's attached to this article.
How to : Getting started with Microsoft Excel in Qlik Application Automation
Stuck at the step 1. You didn't explain how to set up "Create workbook session" but straight go to the second step to add worksheet.
In step 1, it asks drive ID and item ID. Where do we have them?
Thanks
Fei
what is the item ID?
Hi @AfeefaTk
Thanks for your article.
I have a similar use case to the one described in your post. The difference is that the straight table content must be copied and updated to an SQL Table.
¿Are you aware of a similar solution? ¿Any warning or advice?
Thanks in advance for your help.
Cecilia.
Hello @ccaporaso
Please post your question and requirements in the Qlik Application Automation forum to get access to not only our active userbase, but our active support agents.
All the best,
Sonja
Thanks, @Sonja_Bauernfeind ! I'll do it!
Regads,
Cecilia.
Hi @Visual_Intelligence_Support
You can use the do look up functionality to choose value from available options.
Please read through the help text below the input parameters to get a better understanding of how to use it.
Regards
Afeefa TK