4 Replies Latest reply: Sep 2, 2011 11:56 AM by Hans kleijnen RSS

    combining data files

    Hans kleijnen

      Every month I load receive 4 files with the same structure:

       

      LOAD Bookyear,

           Ledger,

           Bookdate,

           Debit,

           Credit

      FROM

      [Ledger 201101.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

       

      I append to the load: MONTH(Bookdate) as Bookmonth,

       

      1. How can I avoid that every month the line MONTH(Bookdate) as Bookmonth must be added. Is it possible to arrange that in 1 line which is valid for the whole QV-file

       

      2. suggestions for a smart method of adding a new month to the previous ones?