Create A Field with 3 values depends on condition

[Shinooj_M]

Hi All,

Need help in creating a field which contains below value

IF (Field1 = 1) then Yes OR (field1=0) then No else Null End as Field1.

Regards.

[TiagoCardoso · Accepted solution]

Hi, im from Brazil.

Sorry for my english.

Try this:

LOAD

IF(Field1 = 1, 'Yes',

     IF(Field = 0, 'No', NULL())) AS Field1