Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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)

View solution in original post

5 Replies
ergustafsson
Partner - Specialist
Partner - Specialist

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
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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
Author

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

Not applicable
Author

Thanks for the advice guys.