Apllymap function not working well

[#1]

Hi All,

In Applymap function can I use more than two parameter values,

Please find below statement,

ApplyMap:
Mapping load * Inline
[
Grade,Score
A,1
B,2
C,3
D,4
];

UsingApplyMap:
LOAD * Inline
[
Emp_Name,Salary,Loc
A,1000,Chennai
B,2000,Bangalore
C,1000,Bangalore
D,1000,Bangalore
E,2000,Bangalore    /* Not available in ApplyMap table
];

load ApplyMap('ApplyMap',Emp_Name,'unassign') as Emp_Grade Resident UsingApplyMap;

Above statement working fine,

But i am looking like,

load ApplyMap('ApplyMap',Emp_Name,’assign,'unassign') as Emp_Grade Resident UsingApplyMap;

Output like,

assign

assign

assign

unassign

Thanks & Regards,

Senthil…

[swuehl · Accepted solution]

Maybe just use a map that has a constant second field value: 'assign',

ApplyMap:
Mapping load Grade, 'assign' as FieldB Inline
[
Grade
A
B
C
D
];

[#3]

Hi Swuehl,

Thanks a lot...

Regards,

Senthil..