I am migrating workflow to knime and i have few multi row formula tools and need help on that.
You’re more likely to get help if you can share some sample data.
1 Like
@Anjum_Taj there are several ways to do this.
The expression language also allows for row offsets.
https://docs.knime.com/latest/knime_expressions_guide/index.html#_row_offsets
2 Likes
@mlauber71, I will check this method and will let you know.
1 Like
I have tried this method using group loop start.
Group loop start(selected 2 columns to group by)
Lag column for sales and gross inventory and then column appender.
In column expression, added the expression same as alteryx with as “column(“sales”,-1)”.
After the loop, it is giving this extra records and not satifying the conditioin this condition for few records where sales value is 0 and gross inventory is not zero, it is giving 0. But, in alteryx its giving values other than 0
As I said earlier, it would be a lot easier if you shared some sample input data and the desired output.
2 Likes
Here is the sample file.
multi row excel sample for post.xlsx (680.1 KB)
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.
2 Likes
Thank you @rfeigel. Let me check this