How to load data from a variable file path?

[#1]

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

[ergustafsson]

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

[#3]

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

[alexandros17 · Accepted solution]

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]

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

[#6]

Thanks for the advice guys.