Reading qvds in loop

[Anonymous]

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

[petter · Accepted solution]

FOR Each File in filelist (Folder & ' \*.QVD')

LOAD

*

FROM $(File) (QVD);

NEXT File

[alexandros17]

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

[Michiel_QV_Fan]

1. Generate a list of files (review Rob Wunderlich website for  list all files in folder solution)
2. 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

[Anonymous]

Hi

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

[alexandros17]

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

[Anonymous]

Hi ,

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

Thanks for your time.

[Anonymous]

Thanks to all for your suggestions