topic Re: Loading qvds from different folders.. in QlikView

Loading qvds from different folders..

Mon, 06 Mar 2017 10:09:41 GMT

Hi All,

i am looking help for below req:

A single app can get qvds from different folders ,, If yes can anyone hep me asap. Thank you..

priyasawant — Mon, 06 Mar 2017 10:47:48 GMT

Hi surya.qv12 yes you can load different QVDs from different folders...

avinashelite — Mon, 06 Mar 2017 10:48:50 GMT

Yes ....mention the path while fetching that

Table1:

LOAD *

from \\C:Folder ;

Table2:

LOAD *

from \\D:Folder ;

Table3:

LOAD *

from \\E:Folder ;

etc

Mon, 06 Mar 2017 11:45:56 GMT

Thanks for your suggestions.

I want like dynamic using conditions or else any configuration or else using variables ...

maxgro — Mon, 06 Mar 2017 12:18:30 GMT

for Each f in 'folder1', 'folder2'

load * from [$(f)\*.qvd] (qvd);

next

Mon, 06 Mar 2017 12:22:58 GMT

Can you please elaborate clearly...

maxgro — Mon, 06 Mar 2017 12:30:02 GMT

The above script loads every qvd from 2 folders

Another option is to create a table with a row for every qvd you want to read (folder name and file name),

loop on that table to to read the qvds