topic Re: Loading Data from QVD in QlikView

Loading Data from QVD

Thu, 13 Nov 2014 07:17:25 GMT

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;

Re: Loading Data from QVD

MK_QSL — Thu, 13 Nov 2014 07:18:52 GMT

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

NoConcatenate

'$(file)':

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

next;

Re: Loading Data from QVD

vardhancse — Thu, 13 Nov 2014 07:25:41 GMT

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);

Re: Loading Data from QVD

amit_saini — Thu, 13 Nov 2014 07:26:26 GMT

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

B,C

FROM $(vQVD)\$(vPlant)_EINHEIT.qvd (qvd)

Thanks,

Re: Loading Data from QVD

Thu, 13 Nov 2014 07:32:20 GMT

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

Re: Loading Data from QVD

its_anandrjs — Thu, 13 Nov 2014 07:37:51 GMT

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