If Then Statement Conversion from Alteryx to Knime

Hello,

I need help converting an If Then Statement from Alteryx to Knime. I’ve tried the String Manipulation, Rule Engine, and Column Expression nodes but can’t seem to get it.

Which node should I use and what is the Knime syntax for the below expression?

if contains([Loc Num],"-") then “SN.”+ [Loc Num]

elseif IsNull([Loc Num]) then “”

elseif IsEmpty([Loc Num]) then “”

elseif Length([Loc Num])<=7 then “SN.”+ padleft([Loc Num],7,“0”)

elseif Length([Loc Num])>7 then “SN.”+ [Loc Num]

else “Check Formula” endif

Any help would be greatly appreciated.

Marie