Set a column in data table like in the Excel formula
I would like to tag rows in a data table in a way I use in MS Excel. Emulating Excel sheet, the original values are in column A, and in column B: B1=“X” and starting from B2 I put formula: =IF(A2>A1;B1;ROW()):
…A…B
1…10…X
2…11…X
3…10…3
Unfortunately in node “Expression” of KNIME referring to previous row of a column is not what I expect. Any idea how to handle that?