topic Re: Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation in Qlik Automate

Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

_amiiine_ — Tue, 21 Jan 2025 10:43:51 GMT

Hello everyone,

I’m currently working on creating an automation using Qlik Application Automation. In this automation, I use Excel blocks, and in each Excel block, there are two inputs: Drive ID and Item ID.

Instead of manually entering these values every time, I’d like to create two variables: one for the Drive ID and another for the Item ID. However, I’m not sure how to make these variables point to the specific Drive ID and Item ID I need.

Does anyone have advice or guidance on how to set this up?

Thanks in advance!

Re: Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

Shai_E — Tue, 21 Jan 2025 15:11:52 GMT

Hi @_amiiine_

What do you mean?
Variables are set with values.

Here is how to use them

Variable block | Qlik Cloud Help

Best Regards

Re: Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

_amiiine_ — Tue, 21 Jan 2025 16:18:07 GMT

Hi @Shai_E ,

The issue is that I don’t know how to retrieve the driveId and itemId values and assign them to my variable block. After that, I need to ensure that in the Excel block, where driveId is an input, it maps correctly to the driveId variable block, and the same goes for itemId. Could you explain how to achieve this?

Thanks in advance!

Best Regards

Re: Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

salmankojar — Wed, 22 Jan 2025 12:22:58 GMT

Hi @_amiiine_ , you need to get the drive ID of the drive where is your excel file located using GET DRIVE block and then you can store the Drive ID in variable for further use.you can do the same for getting Item ID also.

Re: Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

_amiiine_ — Wed, 22 Jan 2025 17:12:02 GMT

hi @salmankojar ,

Thank you it is working.