6 Replies Latest reply: Dec 19, 2016 8:00 AM by Eduardo DImperio RSS

    How Delete a Data?

    Eduardo DImperio

      Hi!

       

      My code finally works and thank to all that help me until now

       

      Well, i have this situation

       

      I receive a OID_METER (numeric) and i join this field whith HOUR(of the last 3 consecutive days) and VALUE.

      Now i need implant a rule that if i get value zero in any hour of any day i must delete this OID_METER from the row, that means, i just need to show OID_METER's that dont get any zero measure.

       

      How can i delete a row in a field?

       

       

      ANALISE_FINAL:

      LOAD

      *

      WHERE

      (ConsumoReal_0 > 0 AND ConsumoReal_1 > 0 AND ConsumoReal_2 > 0)

      AND (ConsumoReal_0>0.005 OR ConsumoReal_1 >0.005 OR ConsumoReal_2>0.005)

      AND (HORA0>=2 AND HOUR0<=5);

      LOAD

        HORA0,

        ID_LEITURA,

          NAME_SYSTEM,

          NAME_GROUP,

          NEIGHB_SYSTEM,

          CITY_SYSTEM,

          OID_METER,

          NAME_TYPE_METER,

          NAME_UC,

          ADDRESS_BLOCK_UC,

          Sum(CONSUMODIA0)AS ConsumoReal_0, //consume of the day

          Sum(CONSUMODIA1)AS ConsumoReal_1, //consume of the day -1

          Sum(CONSUMODIA2)AS ConsumoReal_2 //consume of the day -2

      RESIDENT ANALISE

      GROUP BY

        HORA0,

        ID_LEITURA,

          NAME_SYSTEM,

          NAME_GROUP,

          NEIGHB_SYSTEM,

          CITY_SYSTEM,

          OID_METER,

          NAME_TYPE_METER,

          NAME_UC,

          ADDRESS_BLOCK_UC

      ORDER BY HORA0 DESC;