Hi All,
I am getting this error whenever I try to load my Master Calendar for our Fiscal Year.
"Cannot find field"
Here is what my script looks like:
Table 1:
CCM:
LOAD
visitdate,
visitid,
client_id,
service,
staffid,
provider,
cpt_code,
program,
transfer_date,
"rate",
emp_status
FROM [lib://Q-CCM (tbh_erickd)]
(XmlSimple, table is [Envelope/Body/ExportDataSetResponse/ExportDataSetResult/diffgram/NewDataSet/Table]);
// Master Calendar for fiscal year
Calendar:
Load Dual(fYear-1 &'/'& fYear, fYear) AS FYear,
Dual(Month, fMonth) AS FMonth,
*;
Load Year + IF(Month>=$(vFM), 1,0) As fYear,
Mod(Month-$(vFM),12)+1 As fMonth,
*;
Load Visitdate,
Year(Visitdate) As Year,
Month(Visitdate) as Month,
Week(Visitdate) as Week,
From Resident CCM;
I apologize if this is elementary stuff, I have looked over the information here on the forum but it hasn't clicked just yet.
Any wisdom would be greatly appreciated!
Erick
