2 Replies Latest reply: Dec 15, 2016 1:18 PM by Eduardo DImperio RSS

    Problem Compile code - Field not Find

    Eduardo DImperio

      Hi !

      Im trying compile this code but i dont no why i get a error message.

       

       

      ANALISE_FINAL:

      LOAD

      *

      WHERE

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

      AND (HORA0=2 AND HORA0=5);

      LOAD

        HORA0,

        ID_LEITURA,

          NAME_SYSTEM,

          NAME_GROUP,

          NEIGHB_SYSTEM,

          CITY_SYSTEM,

          OID_METER,

          NAME_TYPE_METER,

          NAME_UC,

          ADDRESS_BLOCK_UC,

          EXCLUDE_OID_METER,

          Sum(CONSUMODIA0)AS ConsumoReal_0,

          Sum(CONSUMODIA1)AS ConsumoReal_1,

          Sum(CONSUMODIA2)AS ConsumoReal_2,

          If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) AS CONSUMO_Noturno_DIA0,

          If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) as CONSUMO_Noturno_DIA1,

          If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0))as CONSUMO_Noturno_DIA2

      RESIDENT ANALISE WHERE OID_METER <> EXCLUDE_OID_METER

      GROUP BY

        HORA0,

        ID_LEITURA,

          NAME_SYSTEM,

          NAME_GROUP,

          NEIGHB_SYSTEM,

          CITY_SYSTEM,

          OID_METER,

          NAME_TYPE_METER,

          NAME_UC,

          EXCLUDE_OID_METER,

          ADDRESS_BLOCK_UC,

      ORDER BY OID_METER, HORA0 DESC;

       

       

      I receive that error:

       

      Ocorreram os seguintes erros:

      Field not found - <ORDER>

      O erro ocorreu aqui:

      LOAD HORA0, ID_LEITURA, NAME_SYSTEM, NAME_GROUP, NEIGHB_SYSTEM, CITY_SYSTEM, OID_METER, NAME_TYPE_METER, NAME_UC, ADDRESS_BLOCK_UC, EXCLUDE_OID_METER, Sum(CONSUMODIA0)AS ConsumoReal_0, Sum(CONSUMODIA1)AS ConsumoReal_1, Sum(CONSUMODIA2)AS ConsumoReal_2, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) AS CONSUMO_Noturno_DIA0, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0)) as CONSUMO_Noturno_DIA1, If(OID_METER= Peek(OID_METER),(Peek(ConsumoReal_0)- ConsumoReal_0))as CONSUMO_Noturno_DIA2 RESIDENT ANALISE WHERE OID_METER <> EXCLUDE_OID_METER GROUP BY HORA0, ID_LEITURA, NAME_SYSTEM, NAME_GROUP, NEIGHB_SYSTEM, CITY_SYSTEM, OID_METER, NAME_TYPE_METER, NAME_UC, EXCLUDE_OID_METER, ADDRESS_BLOCK_UC, ORDER BY OID_METER, HORA0 DESC

       

      any idea why?