topic Re: Reading qvds in loop in QlikView

Reading qvds in loop

Anonymous — Tue, 09 Jun 2015 10:14:22 GMT

Hi All,

I want to load all qvds from specific folder in loop .i have tried it using * .Its working good.

But i want to load it in loop using for and next .

Suggestions are appreciated

Thanks

Re: Reading qvds in loop

petter — Tue, 09 Jun 2015 10:24:19 GMT

FOR Each File in filelist (Folder & ' \*.QVD')
LOAD
*
FROM $(File) (QVD);
NEXT File

Re: Reading qvds in loop

alexandros17 — Tue, 09 Jun 2015 10:24:50 GMT

let path_Alles = '..\..\myDir\myFile_*.xlsx';

for each File in filelist (path_Alles)
MyTable:

LOAD *
FROM $(File) (ooxml, embedded labels, table is Display);
next File

Let me know

Re: Reading qvds in loop

Michiel_QV_Fan — Tue, 09 Jun 2015 10:27:33 GMT

Generate a list of files (review Rob Wunderlich website for list all files in folder solution)
Use this list to load files one by one using variables and peek functions

Generated table with file:

Table:

FilePath,... , .... , .....

Load QVD's:

for i = 1 to noofrows(Table)-1

let file_to_load= peek('FilePath', $(i),'Table');

Data:

Load * $(from file_to_load) (qvd);

next i

Re: Reading qvds in loop

Anonymous — Tue, 09 Jun 2015 10:43:22 GMT

I tried your code but while execution of script it is exiting out of the application.

let path_Alles = 'QvApps Test\New Folder\Qvd Generator\*.qvd';

let File = 'QvApps Test\New Folder\Qvd Generator';

for each File in filelist ('$(path_Alles)')

MyTable:

LOAD *

FROM [QvApps Test\New Folder\Qvd Generator];

STORE MyTable into MyTable2.qvd(qvd);

next File

thanks

Re: Reading qvds in loop

alexandros17 — Tue, 09 Jun 2015 10:52:36 GMT

Try with this but verify if your path is correct ...

let path_Alles = 'QvApps Test\New Folder\Qvd Generator\*.qvd';

or each File in filelist (path_Alles)

MyTable:

LOAD *

FROM $(File)

next File

STORE MyTable into MyTable2.qvd(qvd);

Re: Reading qvds in loop

Anonymous — Tue, 09 Jun 2015 11:33:18 GMT

Hi ,

I think your logic is correct but my path is inccorrect and i had corrected .

Thanks for your time.

Re: Reading qvds in loop

Anonymous — Tue, 09 Jun 2015 11:35:50 GMT

Thanks to all for your suggestions