Field not found

[smilingjohn]

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

[Anil_Babu_Samineni]

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;

[qlikview979]

Hi

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

Dept,

Blazer,

Dot,

Black,

[smilingjohn]

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 ?

[Anil_Babu_Samineni · Accepted solution]

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

[#6]

Hello John,

can you please send me your source file?