Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
_amiiine_
Contributor II
Contributor II

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

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!

Labels (3)
1 Solution

Accepted Solutions
salmankojar
Partner - Creator II
Partner - Creator II

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.

View solution in original post

4 Replies
Shai_E
Support
Support

Hi @_amiiine_ 

What do you mean? 
Variables are set with values.

Here is how to use them

Variable block | Qlik Cloud Help

Best Regards

_amiiine_
Contributor II
Contributor II
Author

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

salmankojar
Partner - Creator II
Partner - Creator II

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.

_amiiine_
Contributor II
Contributor II
Author

hi @salmankojar ,

Thank you it is working.