load multiple QVD files

[#1]

Hi everybody,

     I have folder with many QVD files, which represent whole data model (one qvd file -> one table in data model). I have this code but it only loads all tables into one. Does anybody know why? Thanks for any ideas.

SET vFolder = '.\POLOZKY';

FOR EACH vFileName IN filelist(vFolder& '\*.qvd')

     LET vNameOfTable = QvdTableName('$(vFileName)');

     [$(vNameOfTable)]:      
     load
      *
     from $(vFileName) (qvd);

next vFileName

[alexandros17]

trasform it into:

1. SET vFolder = '.\POLOZKY'; 
2. LET I=0; 
3. FOR EACH vFileName IN filelist(vFolder& '\*.qvd') 
   1. I=$(I)+1
      
4.      LET vNameOfTable = QvdTableName('$(vFileName)'); 
5.  
6.      [$(vNameOfTable)]_$(I):
   1. noconcatenate       
7.      load 
8.       * 
9.      from $(vFileName) (qvd); 
10.       
11. next vFileName 
12. 
    
13. let me know
    

[#3]

Yes, this loads multiple tables, but it does not solve my problem. For each loop in cycle is should load a new table and name of table should by name of file (file .../myTable.qvd -> table name myTable)

[#4]

transform into

Directory;

SET vFolder = = '.\POLOZKY'; 

FOR EACH vFileName IN filelist(vFolder& '\*.qvd') 

     LET vNameOfTable = QvdTableName('$(vFileName)'); 

     [$(vNameOfTable)]:       

     load 

      * 

     from $(vFileName) (qvd); 

next vFileName

Let me know

[maxgro]

SET vFolder = 'C:\Users\yyy\Downloads'; 

FOR EACH vFileName IN filelist(vFolder& '\*.qvd') 

    LET vNameOfTable = QvdTableName('$(vFileName)'); 

   LETvFileBaseName=replace(subfield('$(vFileName)', '\', -1), '.qvd', '');

  trace vFileName=$(vFileName); 

  trace vFileBaseName=$(vFileBaseName);

  trace vNameOfTable=$(vNameOfTable);

     [$(vFileBaseName)]:       

     load 

      * 

     from $(vFileName) (qvd); 

next vFileName 

[Anonymous]

if  your QVD's  have the  same structure try it.

SET vFolder = '.\POLOZKY';

NameTableqvd:

load

*

From $(vFolder)*.QVD

(qvd);

[kwarren1]

This answers Lucie's Question... and mine! Thanks!