Welcome to the KNIME Forum. I hope I understand your question well. I am a little bit confused by row1,2,3 where they are used as columns… See this workflow to help you along Cell splitter and combination.knwf (22.3 KB). I think if you use Regular Expression nodes, you probably need less nodes.
first of all thank you for your fast response! It helps me very good!
There is just one problem: all products from Mo_1 have three 000 and at Mo_2 are the “zeros” missing.
What I want is, that the three zeros will be add if the product is from Mo_2 (or in general if the “zeros” are missing).
As I understand in your solutions, I will get the zeros at Mo_2 but also another zeros at Mo_1. So I will have double zeros at Mo_1 products?!
Is there an opportunity to change it?
And it would be nice, if you can also tell me, how I can change the name of “row4”
You are right, I made a mistake in my flow. Here is a new and better version. Cell splitter and combination.knwf (37.7 KB).
You can change the column name of row4 in two ways in this workflow. Directly in Column Aggregator node or in the Column Rename node. I provided both in the workflow. Hope this helps.
Gr. Hans
Glad I could help you out. You can use a String Manipulation node, and then the substr(string,start) option. In case your new_row4_name is an integer, first convert it to a string with the Number to String node.
gr. Hans