Loading Data from QVD

[#1]

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;

[MK_QSL]

for each file in FileList('C:/Users/Desktop/QVDs/')

NoConcatenate

'$(file)':

Load * from $(file).qvd(qvd);

next;

[vardhancse · Accepted 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:

Main:

LOAD

*,

FROM

[$(QVD_PathI)\QVD_Name]

(qvd);

[amit_saini]

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

[#5]

Thank you all for providing such a quick response!!!

[its_anandrjs]

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