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.
5 Likes
Thank you @rfeigel. Let me check this
Did my workflow work for you?
If my workflow solved your problem please mark solved. If not please provide more details.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
I am migrating workflow to knime and i have few multi row formula tools and need help on that.
Below is the image of configuration of multirow formula. Please provide an alternative approach from alteryx to knime.
Thank you
This is the input for multirow formula tool(sample multirow in sep18.xlsx (1.9 MB))
This is the output, i am getting after multirow formula in alteryx.
sample multirow out spe 18.xlsx (2.0 MB)
You asked this this question in an earlier post and couldn’t be bothered to reply. Don’t repost again.
3 Likes
The user who wanted to confirm the records was on maternity leave. So, couldn’t send the response back.
That still doesn’t explain why you posted the same question twice and haven’t responded to my proposed solution.
Hi @rfeigel the previous thread had been automatically closed so no further comments could be added there.
I have re-opened the original thread and moved these new messages to it to help keep the forum tidy
Hi @Anjum_Taj , as @rfeigel mentioned, there was a potential solution already provided that you said you were going to comment on, so it would have have been better to reference the original topic even if it had closed rather than leaving @rfeigel hanging, as time had been freely given in trying to assist you.
As this new thread has now been moved to the end of that topic, perhaps you could give feedback on the suggestion already provided so that it can be refined/adapted or other suggestions made. thanks.
3 Likes
The provided solution was not matching the exact records. So, i have attached the input file and the output file used to the formula.
(sample multirow out spe 18 is the output file with correct number of records).
Please check the sample files.
Try this. The last input file you uploaded was totally different from the original. Your current input and output files are sorted totally differently. I checked a few of the squad/country combinations and my workflow output seems to match you sample output file.
4 Likes