Copy table from qlik application to excel files

Camille35 — Thu, 18 Jan 2024 13:58:48 GMT

Hi everyone,

I have created an application QLIK with table. I want to send this table in Excel files format by email with QAA.

I have donwload the template "Copy data from a Qlik Sense straight table to an Excel Sheet" by it doesn't work for me.

Can you explain me what is the Drive Id and Item Id ? Drive ID is excel storage ? When I do a lookup, this is my OneDrive.

And for the Item ID, when I do a lookup, I can see all the folders and files in the OneDrive. Should I use a file or a folder in item ID ?

Last question, in my case each execution in the automation must create a new excel files with the current date. It's posible with this template ?

Thank you so much

Re: Copy table from qlik application to excel files

AfeefaTk — Mon, 22 Jan 2024 01:47:51 GMT

Hi @Camille35

Drive ID: This lookup will query a user's drive.
Item ID: ID of an item. Using the lookup a user can query a specific folder to search for Excel sheets. Once you do lookup , you can click on the typing space (path space) and either enter a folder path like "/documents" or "/documents/folder1" where you will see all the files available in a particular folder (in the "path" space), or you can do a lookup to list all the available options (leave the "path" space empty and click on search - this will show you items in the root folder

If you want to create Excel file that contains the current date in the name, Navigate to the 'Name' input parameter of the 'Add Worksheet' block and use the add formula -> search for date formula -> select Date -> enter all the necessary fields.

For eg : Name_{ date: 'now', 'd-m-y' }

Hope this helps!!

Regards

Afeefa TK

topic Copy table from qlik application to excel files in Qlik Automate

Copy table from qlik application to excel files

Re: Copy table from qlik application to excel files