Nested @IF logic in Goldengate

Hi Experts,

I need to write a piece of GG code to check the values of two columns and update the third column in GG replicat file.

I have one column soft_Delete, Here are the below conditions , that needs to be checked :

condition 1 : if column acitve_flg is 'N' then then soft_del column should be updated to 'Y'

condition 2 : if active_flg is 'Y;, soft_del should be ;Y;

Condition 3 : if the other column , desc_text is 'Fault', then Soft_del should be 'Y' and if desc_text is not 'Fault', then soft_del should be 'N'.

I felt, using nested