If Else logic in column expressions

[lailikanabila]

am trying to write a if else logic
howerver the logic seems to fail. The and condition statements don’t seem to work for me. I am referring to all string fields. Do we have a simple if else way to do things since this is frustrating.

my logic is
if(column($INV/Pelunasan Date$) = “” ){
“Belum INV”
}
else if (column($RALExpiredDate$) < “2023-10-01”){
“RAL Tidak Aktif”
}
else if (column($RALExpiredDate$) = “”){
“Tidak Ada RAL”
}
else if (column($RepossesDate$) <= ($RALExpiredDate$)){
“RAL Aktif”
}
else{
“RAL Tidak Aktif”
}

[ipazin]

Hello @lailikanabila,

if you don’t have any calculations you can use Rule Engine node instead of Column Expressions node. It is simpler. Check here for list of options on if else logic in KNIME with more explanation and links:

if then else with multiple conditions

Hello @sgknime, and welcome to KNIME Community! For Rule Engine if else logic see here: For Column Expressions if else logic see here: For Math Formula if else logic see here: In your case I would go with Rule Engine Br, Ivan

Br,
Ivan

[ArjenEX]

Hi @lailikanabila

To add, if you are going the column expression route be aware that the syntax for columns is slightly different: column("RALExpiredDate") instead of column($RALExpiredDate$)

[Daniel_Weikert]

Also in column expression equal sign should be “==” as far as I remember (not a javascript guy just to mention that)
br