4 Replies Latest reply: Dec 23, 2009 4:32 PM by Erik Pos RSS

    Load QVD's with different names into 1 table

    Erik Pos

      Dear All,

      I need to upload history QVD's. These QVD are stored on adaily base and contain the month/year in the description. I don't see how I can automate this process.

      Sample code for 2 months of data:

      //load history QVD snapshots

      Hist_bedrijf:

      load BedrijfLidNummer,

      KEY_BedrijfMaand as H_maand

      from bedrijfcommunity_200912.qvd(qvd);

      load BedrijfLidNummer,

      KEY_BedrijfMaand as H_maand

      from bedrijfcommunity_200911.qvd(qvd);

      .......etc

       

       

      I would prefer to have a flexible code statement where the QVD name contains a variable.

       

      any suggestions ?

       

      Many thanks,

       

      Erik Pos