I have been asked in the last few weeks to help colleagues with replicating an Alteryx workflow that heavily used multi-row functionality, in particular the embedded grouping feature. I am trying to find a way to do this that is streamlined. Is there a metanode or custom component that does this that is not immediately available, OOTB? This is a huge pain point for us and any guidance would be helpful. Been going down a rabbit hole of lags and porting the if, then-else logic into a Java snippet or Column Expressions node and Group Loops. I can eventually get something, but it is a brute force exercise. Here is example of the Alteryx tool [image]

The same question was asked in this post. See if my workflow works for you. [image] Multi row formula from Alteryx to knime KNIME Analytics Platform I’ve never used Alteryx so I’m assuming that the multiple row handling is the same as KNIME. If so, this should work. For some reason the Column Expressions node creates NaN values which I’ve converted back to 0.0. [workflow]

replicate Multi-Row tool from Alteryx

KNIME Analytics Platform

rfeigel June 16, 2025, 2:11pm 3

The same question was asked in this post. See if my workflow works for you.

1 Like