Resident load keeps failing!!! I am missing something, and i cant figure out what it is. I get the error field not found, though it is present in the qvd. Experts please help!!!!!!!!!!!

[Anonymous]

pysix:

load

%pyxis_refresh_key,

TransactionDateTime,

MedDescription,

MedID as %key,

UserID,

TransactionType,

MedClass,

DispenseAmount,

FROM

\\lkmsappbi01\QlikViewSourceDocs\dev\fhcvce\40_QVDGenerators\pyxas\Main_py.qvd

(qvd);

vend_Table:

load

%key,

TransactionType as Type_vend,

TransactionDateTime,

num#(keepchar(DispenseAmount,'0123456789.123')) as disp_amt

resident pysix

where match(TransactionType,'Vend');

FIELD NOT FOUND ERROR

[sunny_talwar]

Can you post a screenshot of the error you are getting?

[vishsaggi]

Remove comma near DispenseAmount on the top like

pysix:

load

%pyxis_refresh_key,

TransactionDateTime,

MedDescription,

MedID as %key,

UserID,

TransactionType,

MedClass,

DispenseAmount,

FROM

\\lkmsappbi01\QlikViewSourceDocs\dev\fhcvce\40_QVDGenerators\pyxas\Main_py.qvd

(qvd);

[Anonymous]

Im sorry for that, the comma is removed in the original script, it was  typo on my part

[maxgro]

add an exit script after your first load

reload

and in table viewer see if you have a pysix table with TransactionType field

[vishsaggi]

Try this ?

vend_Table:

LOAD *

where match(Type_vend,'Vend');

load

%key,

TransactionType as Type_vend,

TransactionDateTime,

num#(keepchar(DispenseAmount,'0123456789.123')) as disp_amt

resident pysix;

[Anonymous]

Field seems to be in the table.

[Anonymous]

[maxgro]

maybe you have a

qualify *;

in your script

so your field names should be

tablename.fieldname     (pysix.TransactionType)

[sunny_talwar]

Your field name is pysix.TransactionType and not TransactionType... You seem to be using Qualify statement somewhere before you load the pysix table. Do you need that? If you do then create the new table with pysix. in front of your field names in the new resident load (except for  %key). If you don't then remove the Qualify and you should be fine.