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

[marcus_sommer]

You used qualifying and therefore you will need to add this table-prefix to your fields within the resident load - or maybe better you removed the qualifying (it caused more problems that it would be useful).

- Marcus

[Anonymous]

Yes i did qualify the key. Wow thank you that works.

[Anonymous]

Thank you maxgro, sunny and vishwarath. All your help was valuable.