Multi Row formula Like Alteryx

[takbb]

I agree with you @Bytecrawler, the only one node solution in KNIME capable of the equivalent of the multi formula in Alteryx is the Java snippet. Details referred to in this thread…

Alteryx Node Multi Row Formula to Knime

Whilst Column Expression’s node is the closest match to the Alteryx Row Formula node, unfortunately I don’t actually think it would be the solution in this case. In the (Alteryx) Row Formula config, it is both creating the “Apply Ratio?” column, and referencing its value in the previous row. Whilst Row Formula can do that, Column Expression cannot (unless there is a very recent change I’ve not seen). Column Expression can be set to retrieve values from previous rows, but not for the Column it …