Field not found DLE

leobrand — Mon, 23 Apr 2018 16:11:33 GMT

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

Mapping

LOAD

%CaseId,

RequestDate

Resident Requests;

Mapping

LOAD

%CaseId,

"Case Created Date"

Resident HelpDeskCases;

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;

Re: Field not found DLE

YoussefBelloum — Mon, 23 Apr 2018 16:18:45 GMT

Hi,

you're trying to load %caseId field from your first tables (CaseLeads, Requests, HelpDeskCases) which do not contain this field..

Re: Field not found DLE

Digvijay_Singh — Mon, 23 Apr 2018 16:57:04 GMT

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

topic Re: Field not found DLE in App Development

Field not found DLE

Re: Field not found DLE

Re: Field not found DLE