topic Re: ApplyMap is not working with SQL in QlikView

ApplyMap is not working with SQL

Wed, 29 Jan 2014 13:25:53 GMT

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

Re: ApplyMap is not working with SQL

kumarnatarajan — Wed, 29 Jan 2014 13:27:18 GMT

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

Re: ApplyMap is not working with SQL

Peter_Cammaert — Wed, 29 Jan 2014 13:30:28 GMT

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

Re: ApplyMap is not working with SQL

MK_QSL — Wed, 29 Jan 2014 13:35:11 GMT

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

Re: ApplyMap is not working with SQL

Thu, 30 Jan 2014 05:05:00 GMT

Hi,

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

Re: ApplyMap is not working with SQL

Thu, 30 Jan 2014 05:06:06 GMT

Hi,

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

Re: ApplyMap is not working with SQL

Thu, 30 Jan 2014 05:14:10 GMT

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

Re: ApplyMap is not working with SQL

tresB — Thu, 30 Jan 2014 05:18:03 GMT

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

Re: ApplyMap is not working with SQL

kumarnatarajan — Thu, 30 Jan 2014 05:22:11 GMT

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

Re: ApplyMap is not working with SQL

jagan — Thu, 30 Jan 2014 05:37:10 GMT

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.

Re: ApplyMap is not working with SQL

Thu, 30 Jan 2014 06:41:16 GMT

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

Thank you