5 Replies Latest reply: Mar 16, 2015 11:27 AM by David Stone RSS

    day sum from hour data

      Hi,

      im loading large amounts of data from a database, and the data is too much detailed for the current task.
      the data was created every hour, but only the sums of each day and month are needed.

       

      The same group by has worked before on other projects and the editor shows no error, but when reloading the script, i just get a script error for the day_sums table.

      Any ideas what could be the problem here ? The qv compiler is not helpfull (as always)

       

      the testdata.xlsx is attached

       

      Dummy_byhours:
      LOAD source,
           mon,
           day,
           hour,
           parameter,
           unit,
      //     sum(Daten),
           DATA as DATA_h
      FROM
      .\test_data.xlsx
      (ooxml, embedded labels, table is Tabelle1);
      
      day_sums:
      noconcatenate LOAD
           source,
           day,
           sum(DATA_h) as DATA_d_sum, // script error here
           unit
      
      RESIDENT Dummy_byhours
      GROUP by day, source
      ;