If Then Else Statement

[Asimkz]

Hi All, I need help in writing out a syntax for a IF THEN ELSE statement. I have below formula that is currently in a Alteryx work and wanted to know what would be equivalent in Knime.

Basically what the formula is doing is replacing a COST field depending on a specific billing type. So where ever it matches that specific billing it overwrites the COST field to 0. Thank you in advance.
IF [Billing Type] = ‘G2’ THEN 0
ELSEIF [Billing Type] = ‘ZG2’ THEN 0
ELSEIF [Billing Type] = ‘ZL2’ THEN 0
ELSEIF [Billing Type] = ‘IG’ THEN 0
Elseif [Billing Type] = ‘L2’ THEN 0
ELSE [Cost] ENDIF

[mlauber71]

@Asimkz you could use column expressions, rule engine or Java Snippet

How to use if expressions in a column expressions node

Hi, sorry that I missed this post concerning the Column Expressions node. In another thread (see here) I broke down the syntax of the Column Expressions and Variable Expressions node and how to use it. I’ve already mentioned that it is possible to use loops (for, while) and if-else statements. As previous posts already mentioned, you have the following syntax: if(**state**) { // do this, if **state** evaluates to true } else { // do that, if **state** evaluates to false } So this is…

Deployment workflow: How to provide a prediction for an unknown value

@LukasB if you want to change values or implement some rules you could try these nodes like Column expressions with an if-then-else rule https://kni.me/n/2_0ji_xeG-SudFu- https://kni.me/n/zpGPAjDyExkFL2HB https://forum.knime.com/t/select-on-single-cell-in-a-table/14805/4?u=mlauber71 https://kni.me/w/OgU2CbKJzzaz90UN

[Asimkz]

I tried the column expressions but I can’t figure out the correct syntax. This is what I have currently have which doesn’t work. Is there an ELSEIF function in Knime?
IF (column(“Billing Type”) = “G2”)
{ 0 }
Else
(column(“Billing Type”) = “L2”)
{ 0 }
Else
(column(“Cost”))

[mlauber71]

@Asimkz yes there is “else if”

If Else in Column Expression – ipazin

[ArjenEX]

Mind that you need to use .equals("") for such string comparisons.

Meaning:

if (column("Billing Type").equals("G2")) {
    0
} else if (column("Billing Type").equals("L2")) {
    0
} else {
    column("Cost")
}

Since the output for both conditions is the same, you can even opt to embed the second one with an OR statement (||).

if (column("Billing Type").equals("G2") || column("Billing Type").equals("L2")) {
    0
} else {
    column("Cost")
}

[Asimkz]

Thank you everyone. The below formula worked. I need to remember that the function needs to be in lower case if vs If or IF
if (column(“billing_type”) == “G2”)
{ 0 }
else if (column(“billing_type”) == “ZG2”)
{ 0 }
else if (column(“billing_type”) == “ZL2”)
{ 0 }
else if (column(“billing_type”) == “IG”)
{ 0 }
else if (column(“billing_type”) == “L2”)
{ 0 }
else
{ column(“cost”) }

[Adrix]

I WOULD use the rule engine node I.O the column expression.
its more intuitive to me .
Not sure why but the sementic the column expression node differs from the rest of the native nodes. which is quite confusing if you are giving the first steps.
Also, when you open the node Rule engine You will see a comment explaining the logic.