3 Replies Latest reply: Feb 17, 2017 7:42 PM by Peter Cammaert RSS

    Data Load Editor - Field Not Found - Qlik Sense

    Andrea Giacomello

      Hi everyone!

      I am completely new to Qlik Sense, and i'm struggling with a auper easy task in the data load editor.

      I am loading a table (from excel) and doing this the program show me the error "Field Not Found", or it does not do any calculation. Hereafter the 2 cases:

       

      [here error: "AAA MESE" FIELD NOT FOUND]

      LOAD

          Date("Mese",'MMMM-YY') as "AAA Mese",

          Score as "AAA Score",

          if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%

      FROM ....

       

      [here any calculation done]

      LOAD

          Date("Mese",'MMMM-YY') as "AAA Mese",

          Score as "AAA Score",

          if("Mese"='42430', 0, ("Score"-Peek("Score", -1))/Peek("Score", -1)) as AAA.Delta%

      FROM ....

       

      Where is the problem? Which field should i have to use in case i renamed before them?

      Thankyou very much!

       

      Andrea

        • Re: Data Load Editor - Field Not Found - Qlik Sense
          Massimo Grossi

          [here error: "AAA MESE" FIELD NOT FOUND]

          LOAD

              Date("Mese",'MMMM-YY') as "AAA Mese",

              Score as "AAA Score",

              if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%

          FROM ....

           

          the field you read is "Mese", not "AAA Mese"  (replace with "Mese"

          the same for Score

          • Re: Data Load Editor - Field Not Found - Qlik Sense
            m w

            LOAD

                Date("Mese",'MMMM-YY') as "AAA Mese",

                Score as "AAA Score",

                if("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%

            FROM ....

             

            You can't refer to "AAA Mese" in the if statement. That field doesn't exist until the load is complete. You'll get the same error for "AAA Score" in the same line.

              • Re: Data Load Editor - Field Not Found - Qlik Sense
                Peter Cammaert

                You can use a preceding LOAD to avoid repeating all your transformation expressions, like in:

                 

                LOAD *,     IF("AAA Mese"='42430', 0, ("AAA Score"-Peek("AAA Score", -1))/Peek("AAA Score", -1)) as AAA.Delta%;

                LOAD

                    Date("Mese",'MMMM-YY') as "AAA Mese",

                    Score as "AAA Score"

                FROM ....

                 

                The first LOAD will use each row produced by the second LOAD as a source to perform further transformations. The resulting table will contain every row produced by the first LOAD.