ApplyMap()

[qlikcheepirishe]

While using Applymap Function not getting required output.

[jonathandienst]

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.

[qlikview979]

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

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;

[Anonymous]

It works perfectly. What is your expected output?

Please find attached application

[qlikview979]

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.

[Anonymous]

Might be you are right

[qlikcheepirishe]

Thnkz @mahesh Kumar for the help