Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can any one suggest me how to do it
I am haning a field with data 0 and 1 and now I wanted to change them 0 to No and 1 to Yes
use applymap function
try this:
map1:
Mapping load * inline
[
field1,substitutevaule
0,No
1,Yes
];
now in your main table
table1:
load
abc,
xyz,
ApplyMap ('map1', mno) as newfield
from table2;
here i am assuming you have 0,1 in mno field
Hi.
In the script:
load
....
if(field=0,'No','Yes') as FldNoYes
sql select...
from...;
Regards.
use applymap function
try this:
map1:
Mapping load * inline
[
field1,substitutevaule
0,No
1,Yes
];
now in your main table
table1:
load
abc,
xyz,
ApplyMap ('map1', mno) as newfield
from table2;
here i am assuming you have 0,1 in mno field