Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
Many Thanks,
Frank
Yes you can. Create a variable, say vPath
vPath = H:\user1\abc.xlsx
LOAD *
FROM
[$(vPath)]
(ooxml, embedded labels, table is [sheet1]);
Yes you can. Create a variable, say vPath
vPath = H:\user1\abc.xlsx
LOAD *
FROM
[$(vPath)]
(ooxml, embedded labels, table is [sheet1]);
Hi Frank,
Check the attachment and let me know.
It's works. Thank You Sunny!
Thanks Tamil. Your suggestion works as well..
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
Check my solution for business users as well as developers.
I don't think for Business users through access point your will work.
I have not tested in access point.
As per my knowledge It will not work as Qlik Architecture. that is a reason I highlighted