Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Resident DateBridge;
Looks like you wanted to rename case id field, you may do like this whereever you have %CaseId present -
CaseID as %CaseId
as of now its trying to search %CaseId in your requests and helpdeskcases tables where it exists as CaseID, not as %CaseId
Hi,
you're trying to load %caseId field from your first tables (CaseLeads, Requests, HelpDeskCases) which do not contain this field..
Looks like you wanted to rename case id field, you may do like this whereever you have %CaseId present -
CaseID as %CaseId
as of now its trying to search %CaseId in your requests and helpdeskcases tables where it exists as CaseID, not as %CaseId