Creating a new field based on multiple field values

[#1]

Hi All,

I have a requirement to derive a new filed (during the load process) based on 4 field values.

I tried to create a new field with nested if statements and that looks awful and very hard to maintain it.

So just wondering whether any of you came across the same scenario and found an easy way ?

if (F1 = 'NO_DATA' , NO_DATA' ,

F1 <> 'NO_DATA' and F2 > 0 and F3 > 0 and F4 = 'NO_DATA' , 'Scenario 1'

and so forth

Thanks in advance,

Aji Paul