topic Re: Field not Found on Resident Load in QlikView

Field not Found on Resident Load

Wed, 26 Jun 2013 21:41:00 GMT

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;

Re: Field not Found on Resident Load

CELAMBARASAN — Wed, 26 Jun 2013 23:56:13 GMT

There is no error on this script.

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

Re: Field not Found on Resident Load

Thu, 27 Jun 2013 05:13:14 GMT

Hi.

Its working..There is no error while Resident TestTable

Regards-Bika

Re: Field not Found on Resident Load

Anonymous — Thu, 27 Jun 2013 09:48:11 GMT

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

Re: Field not Found on Resident Load

Thu, 27 Jun 2013 12:56:02 GMT

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!