Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Yes i did qualify the key. Wow thank you that works.
Thank you maxgro, sunny and vishwarath. All your help was valuable.