topic Re: Field not found in QlikView

Field not found

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

CrossTable (year,data,7)

Load

Dept,

Blazer,

Dot,

Black,

Black&'|'&year&'|'&Dot as %Key

From........

When i load this script i get an error saying that Field year not found.

what should i do to bring the year in here as a key ,

I have considered year in cross table, but still i want to include year in making a key .

Please suggest me what needs to be done

Thanks in advance

Re: Field not found

Anil_Babu_Samineni — Thu, 15 Jun 2017 10:33:05 GMT

Because, you are doing cross table over here, I suggest you to use resident / preceding load to achieve this

Sample:

CrossTable (year,data,7)

Load

Dept,

Blazer,

Dot,

Black

From........

Final:

NoConcatenate

Load Black, year, Dot, Black&'|'&year&'|'&Dot as %Key resident Sample;

Drop Table Sample;

Re: Field not found

qlikview979 — Thu, 15 Jun 2017 10:33:33 GMT

in your field Year is not there only having below fields that's why its showing error.

Dept,

Blazer,

Dot,

Black,

Re: Field not found

smilingjohn — Thu, 15 Jun 2017 10:38:58 GMT

HI Anil

Thanks for the reply .

If i follow your 2nd step that is as follows

Final:

NoConcatenate

Load Black, year, Dot, Black&'|'&year&'|'&Dot as %Key resident Sample;

In my real time application i have many fields , do i nned to consider all the fields in the resident load and then drop the priginal table ?

Re: Field not found

Anil_Babu_Samineni — Thu, 15 Jun 2017 10:41:10 GMT

Yes, Instead of load all fields. You can use LOAD *, ....

Re: Field not found

Thu, 15 Jun 2017 10:51:57 GMT

Hello John,

can you please send me your source file?