Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
FOR Each File in filelist (Folder & ' \*.QVD')
LOAD
*
FROM $(File) (QVD);
NEXT File
FOR Each File in filelist (Folder & ' \*.QVD')
LOAD
*
FROM $(File) (QVD);
NEXT File
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
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
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
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);
Hi ,
I think your logic is correct but my path is inccorrect and i had corrected .
Thanks for your time.
Thanks to all for your suggestions