Changing 1 and 0 into Yes and No (Dual function)

[#1]

HI, please assist with changing the values in this field from 1 and 0 to Yes and No:

[prieper]

Depending the context,

a simple

IF(Job_Close = 0, 'NO', 'YES')

may do the trick.

Else you may have a look into the mapping-functionality, either APPLYMAP or MAP USING ....

HTH Peter

[simospa]

Hi Manus,

dual is used specially whe you have to represent many values in a range with a differente string.

You can use, in you load script, somthing like this:

LOAD ...

if(Job_Closed=0,'NO','YES') as J_Closed,

...

and you can then used this field in your filter.

Alternatively you can use for your list box an Expression (last item on field list) and write =if(Job_Closed=0,'NO','YES')

Let me know if it can be adapted to your project.

S.

[MK_QSL · Accepted solution]

IF(Job_Close = 0, Dual ('NO',0), Dual ('YES',1))

[#5]

Tx Manish, worked like a charm!!!