Fiscal Year: Cannot find field

[erickd1190]

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

[petter]

It seems like the missing field is some field in the CCM which we can't see from this clip of you load script....

[erickd1190]

I updated the post to show the table load as well.

[petter]

Field names are case sensitive in Qlik so visitdate is not the same as Visitdate. That is why it complains about missing field. So just change the Visitdate to visitdate in the last LOAD statement and you should be good to go...

[erickd1190]

Thanks for taking a look. I noticed that when reviewing and made the change. Unfortunately I received the same error. 

[petter]

Then you have to inspect your load script further as it seems like you have overlooked something.

[ahaahaaha]

Hi Erick,

The download window specified field name that is not found?

Regards,

Andrey

[Anonymous]

You don'tr use "from" with the resident load:

LOAD

...

FROM RESIDENT...;

[erickd1190]

When i remove the "From" I get a syntax error stating that I am missing "From".

[m_woolf · Accepted solution]

take out the comma after

Week(Visitdate) as Week,