1 Reply Latest reply: Oct 11, 2012 4:55 AM by Stefan Wühl RSS

    Appending more csv  data to an existing qvd

    Tim Saddler

        Hello

       

      I have a number of csv files in a directory.

       

      For instance...

       

       

      1. A.csv
      2. B.csv
      3. C.csv

       

      On Day 1 I read these into a qvd called TMDATA1 using script
      below:

       

      TMDATA:

       

      LOAD [Paver ID],

          
      [Fleet ID],

          
      Date,

          
      Time,

          
      Longitude,

          
      Latitude,

          
      Satellites,

          
      Odometer,

          
      Pressure,

          
      Temperature,

          
      Humidity,

          
      Windspeed,

          
      [Hopper Temp.],

          
      [Auger Temp.],

          
      [Screed Temp. left],

          
      [Screed Temp. right],

          
      Barcode,

          
      Chainage,

          
      [Running Chainage],

          
      Remarks,

           1
      as Count

          

      FROM

      *.csv

       

      Store TMDATA INTO $(vTMDATA-CSV)TMDATA1.qvd(qvd);

       

      Csv files A.csv,B.csv,C.csv will then be deleted from the directory

       

       

      On Day 2, D.csv,E.csv,F.csv will
      be ftp’d into the same directory.

       

       

      I then want to append these into
      the TMDATA1.qvd

       

      Is there an easy way to do this ?

       

      I tried doing an “add load” but
      this deleted everything from Day 1?

       

       

      Thanks