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?

Excel_Formula_Calc.knwf (80.2 KB)

There are of course multiple ways of doing it, but here is a simple step by step solution that will introduce you to some useful nodes. Not sure exactly what your starting point looks like, so there may be some extra steps you don’t need.

2 Likes