Variable Path for load script

[Anonymous]

Hi All,

I want to know if its possible to have an INPUT BOX with a variable path value that I can use in the load script. What I want to accomplish is to have an Inputbox where user can have the ability to change the file name and path. Instead they have to change in the load script. For example:  I want input box to replace below " ".

LOAD *
FROM

(ooxml, embedded labels, table is [sheet1]);

Many Thanks,

Frank

[sunny_talwar · Accepted solution]

Yes you can. Create a variable, say vPath

vPath = H:\user1\abc.xlsx

LOAD *

FROM

[$(vPath)]

(ooxml, embedded labels, table is [sheet1]);

[tamilarasu]

Hi Frank,

Check the attachment and let me know.

[Anonymous]

It's works. Thank You Sunny!

[Anonymous]

Thanks Tamil. Your suggestion works as well..

[qlikpahadi07]

Hi Fanko1225

Above solution from Sunny will work from Developer machine but correct me if I am wrong. you need to

"have an Inputbox where user can have the ability to change the file name "

For This I assume you might want to provide this flexibility to Business Users on Access point if yes then it will not work. but for any developer " yes it will work".

Might be Helpful

[tamilarasu]

Check my solution for business users as well as developers.

[qlikpahadi07]

I don't think for Business users through access point your will work.

[tamilarasu]

I have not tested in access point.

[qlikpahadi07]

As per my knowledge It will not work as  Qlik Architecture. that is a reason I highlighted