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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ApplyMap is not working with SQL

Following is the code i have written but its giving an error "Field not found - <STATUS>"

Can anybody please help me to solve this???

Status_Map :

MAPPING LOAD

STATUS,

NAME;

SQL SELECT "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

mapping load

"STATUS",

ApplyMap('Status_Map',"STATUS") as status;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

10 Replies
Not applicable
Author

I tried putting status in single quotes and reloaded. It works now

Thank you