Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Field not Found on Resident Load

I am trying to get a resident load to work and I have now simplified the script as much as I can, still I get "Field Not Found" in the Resident Load when running it. Please help me understand what is wrong:

TestTable:

Load

          1+recno() as MyNumber

autogenerate 100;

TEST:

LOAD

          MyNumber as MyNewNumber

Resident TestTable;

Tags (2)
4 Replies
celambarasan
Not applicable

Re: Field not Found on Resident Load

There is no error on this script.

Please check the attached file for the scripts of yours itself.

Not applicable

Re: Field not Found on Resident Load

Hi.

Its working..There is no error while Resident TestTable

script.bmp

Regards-Bika

arunreddy
Not applicable

Re: Field not Found on Resident Load

Hi,

Please insert the new column ie ' ' as Flag, in the resident table

TestTable:

Load

          1+recno() as MyNumber

autogenerate 100;

TEST:

LOAD

          MyNumber as MyNewNumber,

         ' ' as Flag

Resident TestTable;

Regards

Arun M

Not applicable

Re: Field not Found on Resident Load

You are all quite right in that there is nothing wrong in the script. Your answers made me realize that the problem must sit somewhere else, and that somewhere else was a QUALIFY clause in a preceding load. I didn't realize that once QUALIFY is declared it applies to everything afterwards. An "UNQUALIFY *" fixed the problem. But I wouldn't have figured that out this fast without the help from all of you. Thanks!