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 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?