need to change the data in field from 0 to Yes

[#1]

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

[spividori]

Hi.

In the script:

load

....

if(field=0,'No','Yes') as FldNoYes

sql select...

from...;

Regards.

[sushil353 · Accepted solution]

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