applymap map using Defined field

[didierodayo]

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?

[tresesco]

Like this?

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

[tamilarasu · Accepted solution]

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 .............