Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
next file;
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:
Main:
LOAD
*,
FROM
[$(QVD_PathI)\QVD_Name]
(qvd);
for each file in FileList('C:/Users/Desktop/QVDs/')
NoConcatenate
'$(file)':
Load * from $(file).qvd(qvd);
next;
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:
Main:
LOAD
*,
FROM
[$(QVD_PathI)\QVD_Name]
(qvd);
Asma ,
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';
LOAD
A,
B,C
FROM $(vQVD)\$(vPlant)_EINHEIT.qvd (qvd)
Thanks,
AS
Thank you all for providing such a quick response!!!
Hi,
You can try this way
SET vPath ='D:\Data\QVD\';
TableName:
LOAD *
FROM [$(vPath)*.qvd] (qvd);
NOte :- This loads All qvd available in the folder
Regards
Anand