what if the table have dynamic path name

[#1]

If the tables are loaded in Qlikview and if the source data have no fix location then how to solve this problem.

Is their any solution like , the user will pest the path name in a text file  and Qlikview will load the data from that path.

Basically i dont want the user to go to edit script and change the path name.

Can anyone help me ?

[lironbaram]

hi you can work with a config file

load the config file data to variable

for example

the below script will load all csv file from a the folder the user defined

config:

LOAD Filespath,

    Fileextension

FROM

(ooxml, embedded labels, table is Sheet1);

let vFilesPath = peek('Filespath',0,'config');

let vFilesExtension = peek('Fileextension',0,'config');

Load *

From $(vFilesPath)*.$(vFilesExtension);

[#3]

Hi Gaurav,

You can set a variable that includes the .txt file name and location. This will be the same text file where the user will put file name and path: You can further use this variable to extract/store data.

SET vparampath=$(Include=c:\qvpathparamfile.txt);
TEMP_TABLE:
Select * from xyz;

store TEMP_TABLE into $(vparampath)\Settlement.qvd (qvd);

[settu_periasamy]

You can try this also,

Create the InputBox-> assign variable (you can paste the Path or Filename in the input box)

Then you can use this variable in the backend

[antoniotiman]

Hi,

in Your script You can use Input Function

vPath=Input('Enter PathName of Loading File');

Load *

From $(vPath);

Regards,

Antonio