topic Re: ApplyMap() in QlikView

ApplyMap()

qlikcheepirishe — Wed, 25 Nov 2020 16:16:04 GMT

While using Applymap Function not getting required output.

Re: ApplyMap()

jonathandienst — Mon, 15 May 2017 10:01:10 GMT

Looks OK. Whats are you getting as output and what do you expect?

The amount and accuarcy of the advice you will receive here is directly proportional to the amount of information you supply.

Re: ApplyMap()

qlikview979 — Mon, 15 May 2017 10:06:41 GMT

Hi do like this

T1:

mapping LOAD *Inline [

Name,Age

CS,23

Mahesh,24

Dhaval,23

Rutale,24

Rajini,24

Swati,24

];

T2:

LOAD * Inline [

Name,Surname,

CS,Shukla

Mahesh,Cheepiri

Dhaval,Vyas

Swati,moku

Shreya,shukla

];

NoConcatenate

T2:

LOAD

RecNo() as Rec,

Name,Surname,

ApplyMap('T1',Name,'Missing') as Age

Resident T2;

DROP Table T2;

Re: ApplyMap()

Anonymous — Mon, 15 May 2017 10:08:00 GMT

It works perfectly. What is your expected output?

Please find attached application

Re: ApplyMap()

qlikview979 — Mon, 15 May 2017 10:16:23 GMT

I think,

As per second table CS name having two times ,may be he is expecting two times same name in front end also,for that we need to add recno() function.

Re: ApplyMap()

Anonymous — Mon, 15 May 2017 10:27:13 GMT

Might be you are right

Re: ApplyMap()

qlikcheepirishe — Mon, 15 May 2017 12:19:40 GMT

Thnkz @mahesh Kumar for the help