Columns expression vs Expression node
Recently I updated my knime version and I cannot use anymore the column expression node, because of this, I am replacing the information in that nodes for new expression in the EXPRESSION node:
But for some cases, I cannot use it, because it doesn’t has the functions I used before)
example I want to do this:
if (isMissing($[“ID Number”])) { MISSING }
else { join(left($[“ID Number”], 6), “/”, right($[“ID Number”], 4)) }
but there is no alternative in EXPRESSION node to check if the value in a column is missing, or to use the left and right functions as I used in column expression node- so now is very difficult to find how to do this
Is someone facing this too?