Transformer condition

[kennyapril]

The input to a transformer contains 8 fields
ID
year
sts
mbr
year1
sts1
year2
sts2

the output should contain only 2 fields.
ID
year (OR) year1 (OR) year2


ID remains the same
and for getting the other one below conditions should be applied

if sts--Active then "year"
else if mbr--Y
then "year"
else

if sts1---Active
then"Year1"

else
if sts2-----Active
then "year2"

Is this valid in the transformer (If Then Else) condition

pls let me know!!!

[anbu]

You might need to another else statement at the end.

Try and let us know if you have problems

[ray.wurlod]

You DO need another Else clause at the end.

If..Then..Else is an expression, and must produce a value whether or not the test expression is true.