Field Location Not Found Error

[danaleota1]

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;

[felipedl]

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]

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

[felipedl]

No problem, glad it helped :).