Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to load data from a variable file path?

Hi Everyone,

how can i use  variable with file path("") value and use it as my data source.

example:

in my sheet 1, I have created a input box and variable "file_pathname" with the value of " ".

i need "file_pathname" to be my data source

LOAD

   Call_Start,

   Call_End

FROM

"file_pathname"

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

is this possible?

Thanks,

Jhondel

1 Solution

Accepted Solutions

Re: How to load data from a variable file path?

If you have loaded your script, even if you define a variable you cannot load the sctipt again with that variable (UI comes after Script load)

5 Replies
erikadvectas
Valued Contributor

Re: How to load data from a variable file path?

Hi Jhondel,

This is very possible.

In the "Data Load Editor" of Sense Desktop you can add and edit connections.

On the right side of the program you can add "Libraries". For XLS files, you will add the folder, and then link to the XLS file.

Thus the library "Data sources" will always stay the same, even if you move the folder and update the path.

Let me know if this answers your question.

Regards,

Erik

Not applicable

Re: How to load data from a variable file path?

Just want to add that beside the new library function you still can use the old script with the variable as Path.

Re: How to load data from a variable file path?

If you have loaded your script, even if you define a variable you cannot load the sctipt again with that variable (UI comes after Script load)

Not applicable

Re: How to load data from a variable file path?

Missed the point with the input box, so this is actual not possible.

Not applicable

Re: How to load data from a variable file path?

Thanks for the advice guys.

Community Browser