topic Re: apply map error : field not found in QlikView

apply map error : field not found

Mon, 23 Sep 2013 06:18:00 GMT

Hi,

I am having an error with apply map. It says field not found<psp_status> while loading table svr_rpx

status:

mapping load * inline [
psp_staus,psp_status_exp
R,Reserved
];

svr_rpx:

load psp_status,applymap('status',psp_status) as psp_status;
select psp_status from

svr_rpx_missing1 ;

Please help me out with the syntax.

Thanks,

Anju

Re: apply map error : field not found

Mon, 23 Sep 2013 09:11:50 GMT

Hi Anju,

Kindly make sure about the field psp_status in the underlying table. Also why you are trying to do the proceeding load?

-Jay

Re: apply map error : field not found

jagan — Mon, 23 Sep 2013 09:37:19 GMT

Hi Anju,

Try this script, it is working

status:
mapping load * inline [
psp_staus,psp_status_exp
R,Reserved
];

svr_rpx:
load psp_status,
applymap('status', psp_status) as psp_status_value;
load * inline [
psp_status
R
];

Regards,

Jagan.

Re: apply map error : field not found

tresB — Mon, 23 Sep 2013 09:45:21 GMT

Try like this:

MapTable:

mapping load * inline [
psp_staus,psp_status_exp
R,Reserved
];

svr_rpx:

load psp_status,applymap('MapTable',psp_status) as Mapped_psp_status;
select psp_status from

svr_rpx_missing1 ;

Note: Changes are in red.

Re: apply map error : field not found

Thu, 03 Oct 2013 12:38:55 GMT

Hi Tresesco,

I tried this .But this did not work for me.

Thank You!

Re: apply map error : field not found

Thu, 03 Oct 2013 12:46:35 GMT

You'll need to have the same field loaded twice in the SQL as well.

load psp_status,applymap('MapTable',psp_status) as Mapped_psp_status;
select psp_status,psp_status from

svr_rpx_missing1 ;

Re: apply map error : field not found

Thu, 03 Oct 2013 12:51:50 GMT

Hi All,

I was able to solve it.There seems to be a bug.

It works when psp_status is in capital letters.

svr_rpx:

load *,applymap('status',PSP_STATUS) as psp_status_new;
select PSP_STATUS from

svr_rpx_missing1 ;

Regards,

Anju