topic Re: Script Error in QlikView

Script Error

Thu, 27 Aug 2015 02:04:59 GMT

Hi,

Im having a problem, I load a data and it says that the field is not found, but in the DB the field is there,

These are the field I load in DB:

BldgAssmt:

LOAD "area",

BINum,

depreciation,

MDINum,

Parcel,

PCINum,

pin,

SINum,

"unit-val",

yr;

SQL SELECT "area",

BINum,

depreciation,

MDINum,

Parcel,

PCINum,

pin,

SINum,

"unit-val",

FROM PUB."Bldg-ASSMT";

But when it comes to QVD, the the first field has a script error:

Field not found - <area>

BldgAssmt:

LOAD "area",

BINum,

depreciation,

MDINum,

Parcel,

PCINum,

pin,

SINum,

"unit-val",

FROM

(qvd)

Please Help me on this

Re: Script Error

Ralf-Narfeldt — Thu, 27 Aug 2015 05:32:30 GMT

If you do

LOAD *

FROM

(qvd);

Do you get the area field loaded?

Re: Script Error

sunny_talwar — Thu, 27 Aug 2015 05:45:43 GMT

May be try area without the double quotes around it

Re: Script Error

Thu, 27 Aug 2015 06:03:26 GMT

i figure it out guys, I stored it in the wrong table. LOL
I check it and the problmes is this:

Store Owner into C:\Users\SAMSUNG\Desktop\Lester RPTAS\RPTAS NEW\BldgAssmt.qvd;

It should be this:

Store BldgAssmt into C:\Users\SAMSUNG\Desktop\Lester RPTAS\RPTAS NEW\BldgAssmt.qvd;