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?
