How to access newly created values in multi-row expression
I’ve created a simple example to illustrate a frustration I’ve encountered using the Labs Column Expressions node to perform a multi-row expression
In this case I’m just creating a running total, in which the result is the current value of a Counter column plus the Running Total from the previous row
In Alteryx this is a doddle using the Multi-Row Formula Tool which, crucially, exposes access to the newly created Running Total field within the tool itself. I can therefore create a simple expression that references the new field that I’m creating, see below
I haven’t figured out a way in KNIME to reference the newly created output column, so I’ve had to resort to a slightly fiddly intermediate variable to keep track of my desired total. Please tell me which node is better suited to multi-row calculations so that I can reference the new column as part of running the node. Thanks
