Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Data Load Editor - Field Not Found - Qlik Sense

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

1 Solution

Accepted Solutions

Re: Data Load Editor - Field Not Found - Qlik Sense

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.

3 Replies
MVP
MVP

Re: Data Load Editor - Field Not Found - Qlik Sense

[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

mwoolf
Honored Contributor II

Re: Data Load Editor - Field Not Found - Qlik Sense

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

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.