6 Replies Latest reply: Dec 20, 2016 12:59 PM by Eduardo DImperio RSS

    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

        • Re: Table doesnt load
          Shraddha Gajare

          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');

            • Re: Table doesnt load
              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;

            • Re: Table doesnt load
              Shraddha Gajare

              can you share the sample app with sample data

              • Re: Table doesnt load
                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;

                • Re: Table doesnt load
                  Massimo Grossi

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

                  • Re: Table doesnt load
                    Eduardo DImperio

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