Hi Guys,
I'm getting this error when loading from a resident table and i cannot figure out why. <ID> is not a field i've used or stated that i require.
Error is as follows;
Field not found - <ID>
SaveFile:
Load InboundCallTrackingTblID,
CallID,
CalledNumber,
CallerNumber,
AgentID,
Action,
Answered,
AnsweredNoVoicemail,
Missed,
InternalOverFlowTimeOut,
InternalOverFlowToLongWaiting,
InternalOverFlowToManyWaiting,
InternalOverFlowCalendar,
InternalOverFlowHoliday,
InternalOverFlowManual,
InternalOverFlowNoAgent,
ExternalOverFlowTimeOut,
ExternalOverFlowToLongWaiting,
ExternalOverFlowToManyWaiting,
ExternalOverFlowCalendar,
ExternalOverFlowHoliday,
ExternalOverFlowManual,
ExternalOverFlowNoAgent,
StartTime,
CallDate,
CallHour,
CallMinute,
CallTime,
CallTableDate,
MinutesThirty,
MinutesFifteen,
EndTime,
Duration,
WaitDuration,
HoldTimeDuration,
SkillID,
CallerTitle,
CallerName,
CallerSureName,
CallerCompany,
BrandExAdmin,
CallerStreet,
CallerZIP,
CallerCity,
CallerCountry,
CallerPhone,
VIPClassID,
PhoneClassID,
connected,
TransferID1,
TransferID2,
TransferID3,
TransferID4,
PhoneCallStart,
Classification,
PickAgentName,
PickMode
Resident Inbound
Where Date(CallTableDate) < '06/03/2014'
I'm not referencing a field called <ID> so where is it getting this from? I've also tried replacing the list with
LOAD *
but, again, it says it cannot find the field <ID>.
Anyone got any ideas?
Regards,
Nick
