ApplyMap is not working with SQL

[#1]

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";

[kumarnatarajan]

Hi,

Remove the mapping word in abc table

Ex:

Status_Map :

MAPPING LOAD

STATUS,

NAME;

SQL SELECT "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

load

STATUS,

ApplyMap('Status_Map',STATUS) as status;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

[Peter_Cammaert]

And the double quotes around the two STATUS names in the preceding load for abc can go as well. A preceding load follows QlikView syntax, not SQL syntax.

Peter

[MK_QSL]

Status_Map :

MAPPING LOAD

     STATUS,

     NAME;

SQL SELECT

     "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

Load

"STATUS",

ApplyMap('Status_Map',STATUS) as NAME;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

[#5]

Hi,

Thanks for the reply, I tried reloading after removing mapping word, still its not working.

[#6]

Hi,

Thanks for the reply, I made all the changes you have mentioned, still its not working.

[#7]

Status_Map :

MAPPING LOAD

     STATUS,

     NAME;

SQL SELECT

     "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

Load

"STATUS",

ApplyMap('Status_Map',STATUS) as STATUS1;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

[tresesco]

Have you tried the code that Kumar Natarajan suggested? What is the error message you are getting there?

[kumarnatarajan]

HI kanvi,

First check your mapping table status and applymap table status field value format.

The below syntax are right.

Status_Map :

MAPPING LOAD

STATUS,

NAME;

SQL SELECT "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

load

STATUS,

ApplyMap('Status_Map',STATUS) as Name;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

[jagan]

Hi,

Try this

Status_Map :

MAPPING LOAD

STATUS,

NAME

WHERE 1=1;

SQL SELECT "STATUS",

    "NAME"

FROM "STATUS_TABLE";

abc:

load

ID,

STATUS,

ApplyMap('Status_Map',STATUS) as Name;

SQL SELECT "ID",

    "STATUS",

FROM "XYZ";

Regards,

Jaan.