Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading Data from QVD

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;

1 Solution

Accepted Solutions
vardhancse
Not applicable

Re: Loading Data from QVD

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

5 Replies
MK_QSL
Not applicable

Re: Loading Data from QVD

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

NoConcatenate

'$(file)':

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

next;

vardhancse
Not applicable

Re: Loading Data from QVD

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
Not applicable

Re: Loading Data from 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

Not applicable

Re: Loading Data from QVD

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

its_anandrjs
Not applicable

Re: Loading Data from QVD

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