Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
leobrand
Contributor III
Contributor III

Field not found DLE

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;

1 Solution

Accepted Solutions
Digvijay_Singh

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

View solution in original post

2 Replies
YoussefBelloum
Champion
Champion

Hi,

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

Digvijay_Singh

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