Table doesnt load

[eduardo_dimperio]

Hi,

Why my table Analise_Final doesnt load?

The only table that remains is Exclusao.

Exclusao:

LOAD

HORA,

OID_METER AS EXCLUDE_OID_METER

RESIDENT ANALISE_TMP

WHERE CONSUMODIA0=0 OR CONSUMODIA1=0 OR CONSUMODIA2=0;

ANALISE_FINAL:

LOAD

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    ADDRESS_BLOCK_UC,

   ConsumoReal_0,

   ConsumoReal_1,

   ConsumoReal_2

RESIDENT ANALISE WHERE (HORA0=2 OR HORA0=5);

DROP TABLE ANALISE_TMP,ANALISE;

EXIT SCRIPT

[shraddha_g]

try with

ANALISE_FINAL:

LOAD

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    ADDRESS_BLOCK_UC,

   ConsumoReal_0,

   ConsumoReal_1,

   ConsumoReal_2

RESIDENT ANALISE WHERE (HORA0='2' OR HORA0='5');

[eduardo_dimperio]

Nope, unfortunately even remove the "where" its still not working

ANALISE_FINAL:

LOAD

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    ADDRESS_BLOCK_UC,

   ConsumoReal_0,

   ConsumoReal_1,

   ConsumoReal_2

   RESIDENT ANALISE;

[shraddha_g]

can you share the sample app with sample data

[shubham_singh]

Try this

Exclusao:

LOAD

HORA,

OID_METER AS EXCLUDE_OID_METER

RESIDENT ANALISE_TMP

WHERE CONSUMODIA0=0 OR CONSUMODIA1=0 OR CONSUMODIA2=0;

NOCONCATENATE

ANALISE_FINAL:

LOAD

  HORA0,

  ID_LEITURA,

    NAME_SYSTEM,

    NAME_GROUP,

    NEIGHB_SYSTEM,

    CITY_SYSTEM,

    OID_METER,

    NAME_TYPE_METER,

    NAME_UC,

    ADDRESS_BLOCK_UC,

   ConsumoReal_0,

   ConsumoReal_1,

   ConsumoReal_2

RESIDENT ANALISE WHERE (HORA0=2 OR HORA0=5);

DROP TABLE ANALISE_TMP,ANALISE;

[maxgro · Accepted solution]

It seems from your image your last load concatenates to ANALISE table instead of make a new ANALISE_FINAL table;

this happens because Qlik auto concatenates the rows of a load to a previously loaded table if the number and names of fields are the same

I think Shubham Singh is right, add a noconcatenate

ANALISE_FINAL:

noconcatenate

load

     ...

drop table ...

[eduardo_dimperio]

Yeap, the both table are the same, with some diferent filters. Thank you all