Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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