If Then Statement Conversion from Alteryx to Knime

Hi @mariesylvia , you can check the workflow I provided in this other thread where I am using a Column Expression with if else if, and with join() which pretty much covers most of what you need.

For padleft, the synxtax is the same, except that the function is padLeft(). You can click on the function dropdown in the Column Expression to see all the available functions. You can also use the function by clicking on it in the dropdown. Similarly, you can use a column or variable by clicking on it from the column or variable dropdown.