Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
Yes that is what it was. Thank you for pointing that out!
No problem, glad it helped :).