I'm having trouble to do an IF-THEN-ELSE IFn-ELSE statement using data rules in Information Analyzer; it looks like 'ELSE IF' is not supported. Only the IF-THEN-ELSE condition statement is working.
IF UCASE(Gender) = 'M' THEN 'Male'
ELSE IF UCASE(Gender) = 'F' THEN 'Female'
Does anyone of you have tried to make similar expression that have nested IF statements in data rules?