Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Not applicable

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
Not applicable

Re: Table doesnt load

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

6 Replies
shraddha_g
Not applicable

Re: Table doesnt load

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_dimperi
Not applicable

Re: Table doesnt load

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
Not applicable

Re: Table doesnt load

can you share the sample app with sample data

shubham_singh
Not applicable

Re: Table doesnt load

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
Not applicable

Re: Table doesnt load

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_dimperi
Not applicable

Re: Table doesnt load

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