Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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…
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
];
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
];
Hi Swuehl,
Thanks a lot...
Regards,
Senthil..