Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Table doesnt load

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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 ...

View solution in original post

6 Replies
shraddha_g
Partner
Partner

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
Specialist II
Specialist II
Author

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
Partner
Partner

can you share the sample app with sample data

shubham_singh
Partner
Partner

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
MVP
MVP

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 ...

View solution in original post

eduardo_dimperio
Specialist II
Specialist II
Author

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