Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

applymap map using Defined field

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?

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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

View solution in original post

2 Replies
tresesco
MVP
MVP

Like this?

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

tamilarasu
Champion
Champion

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