Discussion Board for collaboration on QlikView Scripting.
I have to load all the QVDs present in a folder.
I have used the below code in the script. But it is not loading anything.
for each file in FileList('C:/Users/Desktop/QVDs/')
Load * from $(file).qvd(qvd);
Go to Solution.
set the path first in the first tab, before loading the tables from QVD.
SET QVD_Path = '..\..\..\..\..\QVD\IT\Fact';
So that while loading each QVD:
You can do this way:
Suppose you have folder named as QV_QVD where all qvds are present . I'm considering you are having qvds names for example ABC_EINHEIT.qvd , XYZ_EINHEIT.qvd ...etc.
Now suppose you want to load a qvds for only ABC than use this script below:
Set vPlant = 'ABC';
Set vQVD = '\.......\QV_QVD';
FROM $(vQVD)\$(vPlant)_EINHEIT.qvd (qvd)
Thank you all for providing such a quick response!!!
You can try this way
SET vPath ='D:\Data\QVD\';
FROM [$(vPath)*.qvd] (qvd);
NOte :- This loads All qvd available in the folder