topic Re: applymap map using Defined field in QlikView

applymap map using Defined field

didierodayo — Fri, 02 Dec 2016 04:17:07 GMT

Hello I have this applymap challenge and need some help.

LOAD
*,
ApplyMap('Getnumber' , number,number) as [Number New],

ApplyMap('Getpostcode',ApplyMap('Getnumber' , number,number),postcode)as postcode

FROM .............

Instead of writing the query that way to get the postcode using the number could I use the new field name I have just defined[Number New], ? how is it achieved?

Re: applymap map using Defined field

tresB — Fri, 02 Dec 2016 04:27:42 GMT

Like this?

ApplyMap('Getpostcode',ApplyMap('Getnumber' , number,number), ApplyMap('Getnumber' , number,number) )as postcode

Re: applymap map using Defined field

tamilarasu — Fri, 02 Dec 2016 04:30:33 GMT

Hi Didier,

How about using preceding load instead?

LOAD *,

ApplyMap('Getpostcode',[Number New],postcode) as postcode;

LOAD *,
ApplyMap('Getnumber' , number,number) as [Number New]

FROM .............