1 Reply Latest reply: Apr 21, 2015 6:42 AM by Philipp Holzemer-Zerhusen RSS

    pick data using generic load

      Hello,

       

      I have a script in which a Table from a database ([TimeStamp],[DataName],[Value]) is loaded using the generic load. The Table is large and causes a long loading time. On top of that in a certain script it also causes a crash. I would like to pick several entries and not load those, I don't need. This is a part of the script:



      LOAD Floor(Timestamp) as %Datum,
                Dataname,
               
      Sum(Value) as Value

      Group By Timestamp, Dataname
      ;
      SQL SELECT
          Timestamp,
           Dataname,
           Value
           FROM MySource;

       

       

      A calander follows which I left out for better clarity. Do you have any idea how to solve the problem. Thank you in advance.

       

       

      Greetings!