Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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);
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);
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
Hi,
in Your script You can use Input Function
vPath=Input('Enter PathName of Loading File');
Load *
From $(vPath);
Regards,
Antonio