Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota1
Creator
Creator

Field Location Not Found Error

Hi I'm still new to Qlik.  

After loading the table and creating a new field.  I tried to drop the field I no longer need: Location but get the field not found error.  

 

LOAD
DateCompleted,
CallDate,
AddedBy,
AgentName,
Supervisor,
Manager,
Location,
IF(Location = 'ALLEN PARK', 'Allen Park', IF(Location = 'PHOENIX', 'Phoenix', IF(Location = 'ST PETERSBURG', 'St Petersburg', Location))) as Errors_Site,
CallType,
FormType,
"ValidError(Inquiry only)",
CoachingDetails,
CoachingErrorType,
CallInfoType,
CreditUnionName,
Segment,
CallId
FROM [lib://AttachedFiles/April_May_Errors.xlsx]
(ooxml, embedded labels, table is Errors)
WHERE "ValidError(Inquiry only)" = ('Yes') AND FormType <> 'Complaint' AND FormType <> 'Compliment';

Drop Field Location From Errors;

Labels (3)
3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

I'm assuming you didnt name your table Errors, so Qlik cant field in the field in the specified table, hence the error message:
Drop Field Location From Errors;

danaleota1
Creator
Creator
Author

Yes that is what it was.  Thank you for pointing that out!

felipedl
Partner - Specialist III
Partner - Specialist III

No problem, glad it helped :).