Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Hi @_amiiine_
What do you mean?
Variables are set with values.
Here is how to use them
Variable block | Qlik Cloud Help
Best Regards
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
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.
hi @salmankojar ,
Thank you it is working.