Apply Multiple IF Conditions on a New Column

Hi Dmitry,

Is there s way to apply multiple IF conditions to a newly added column?
Something like:
IF [Existing Column]=‘A’ THEN [New Column] =‘Aa’
ELSEIF [Existing Column]=‘B’ THEN [New Column] =‘Bb’
ELSEIF [Existing Column]=‘C’ THEN [New Column] =‘Cc’
END IF

Thank you.

Hi Lianne,

Take a look at the Rule transformation.