LEFT JOIN USING WHILE

[eduardo_dimperio]

Hi,

I'm trying this, but with no sucess. Please i need some help.

ANALISE_TMP:

LOAD

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    TYPE_CONSTANT,

    NAME_UC,

    ADDRESS_BLOCK_UC,

    DATE_READ

  RESIDENT TMP2;

Set dia=0

Do while dia<=2   

left join (ANALISE_TMP)

LOAD

    OID_METER,

    VALUE_READ * TYPE_CONSTANT AS CONSUMODIA$dia

RESIDENT TMP2

where FLOOR(DATE_READ)=FLOOR(TODAY()-$dia);

Let dia=dia+1;

LooP

//Ocorreram os seguintes erros:

//Script line error:: return

---

//O erro ocorreu aqui:

//LooP

[sunny_talwar · Accepted solution]

May be this:

left join (ANALISE_TMP)

LOAD

    OID_METER,

    VALUE_READ * TYPE_CONSTANT AS CONSUMODIA$(dia)

RESIDENT TMP2

where FLOOR(DATE_READ)=FLOOR(TODAY()-$(dia));

[rubenmarin]

Hi Eduardo, try using the $-expansion with parenthesys:

left join (ANALISE_TMP)

LOAD

    OID_METER,

    VALUE_READ * TYPE_CONSTANT AS CONSUMODIA$(dia)

RESIDENT TMP2

where FLOOR(DATE_READ)=FLOOR(TODAY()-$(dia));

Let dia=dia+1;

LooP

[rubenmarin]

You always faster.

[eduardo_dimperio]

Wow, was really fast.

Thank you for that Ruben, but still not working.

Set dia=0

Do while dia<=2   

left join (ANALISE_TMP)

LOAD

  OID_METER,

    VALUE_READ * TYPE_CONSTANT AS CONSUMODIA$(dia)

RESIDENT TMP2

where FLOOR(DATE_READ)=FLOOR(TODAY()-$(dia))

ORDER BY OID_METER,DATE_READ DESC;

Let dia=dia+1;

LooP

I get the same error as before

[eduardo_dimperio]

Indeed lol

[eduardo_dimperio]

Guys I think i have resolve the problem.

I miss to put a ; after set my variable dia.

But thank you some much