I attached a screen shot of a data load error from the Data Load Editor. I have three sections of code Main, DateBridge, and CanonicalCalender which I provided below. Based on the attached screen shot and code below from the Data Load Editor, can you help me understand why I am getting this data load error?
Section: Main
LOAD
OwnerID,
"Case Owner",
"Case Owner Group",
"Employee Status"
FROM [lib://Data/HelpDeskCases.xlsx]
(ooxml, embedded labels, table is CaseLeads);
LOAD
CaseID,
OwnerID,
RequestDate,
Subject
FROM [lib://Data/HelpDeskCases.xlsx]
(ooxml, embedded labels, table is Requests);
LOAD
CaseID,
"Case Aging",
"Case Closed Date",
"Case Count",
"Case Created Date",
"Case Duration Time",
"Case Is Closed",
"Case Record Type",
"Case Timetable",
"Case Timetable Rank",
CaseNumber,
"Cases Open/Closed",
Priority,
"Priority Rank",
"Priority Sort",
Status
FROM [lib://Data/HelpDeskCases.xlsx]
(ooxml, embedded labels, table is HelpDeskCases);
Section: DateBridge
// mapping tables
A:
Mapping
LOAD
%CaseId,
RequestDate
Resident Requests;
B:
Mapping
LOAD
%CaseId,
"Case Created Date"
Resident HelpDeskCases;
C:
Mapping
LOAD
%CaseId,
"Case Closed Date"
Resident HelpDeskCases;
// end of mapping tables
// create DateBridge table
DateBridge:
LOAD
%CaseId,
ApplyMap('A',%CaseId,Null()) as CanonicalDate,
'RequestDate' as DateType
Resident HelpDeskCases;
LOAD
%CaseId,
ApplyMap('B',%CaseId,Null()) as CanonicalDate,
'Case Created Date' as DateType
Resident HelpDeskCases;
LOAD
%CaseId,
ApplyMap('C',%CaseId,Null()) as CanonicalDate,
'Case Closed Date' as DateType
Resident HelpDeskCases;
Section: CanonicalCalender
// create CanonicalCalendar
CanonicalCalendar:
LOAD CanonicalDate,
Day(CanonicalDate) as Day,
Month(CanonicalDate) as Month,
Year(CanonicalDate) as Year,
Date(MonthStart(CanonicalDate),'MMM-YYYY') as MonthYear
