Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
While using Applymap Function not getting required output.
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.
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;
It works perfectly. What is your expected output?
Please find attached application
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.
Might be you are right
Thnkz @mahesh Kumar for the help