2 Replies Latest reply: Feb 23, 2018 7:00 AM by Magnus Rydberg RSS

    Error when using SUM and GROUP BY in sqript

    Magnus Rydberg

      I am running this sqript using SUM and GROUP BY function in a load statement:

       

      LOAD

          StringKey1 as ContLONumber,

          StringKey4 as ContSequence,

          Status as ContStatus,

          Sum("Time") as ContLogTime

          Group By StringKey1;

          SQL SELECT * FROM "MyL_PROD_220".OTSDATA.TimeLog where StringKey6='CONT';

       

      When executing the sqript I'll got the error message "invalid expression"

      What is not correct in my sqript?