Good Day, dear KNIME Users
I have trouble with combining two fields
In my workflow I have two outputs with different columns, I have to combine them(append them)
I have used Column Combiner
In the first data after rowId I have rowid and Name, in second data I have only one value (max ID)
My task is to combine them
The output should be like this
After Combiner Tool I have the following output
I’m a bit confused. You say Column Combiner but you are mean Column Appender node? Also I see some Joiner nodes and probably that’s what you need instead of Column Appender/Combiner. But it would be best if you can share some input data from two output ports you have (dummy data works just fine!) so we can understand it and help
In Alteryx I have found tool Column Appender, it puts the value for the rest of the rows.
So, as you can see here max record id filled to each row
In KNIME max record id filling only to the first row
ok. Maybe I got it now. You shouldn’t use Column Appender node in this case but rather Cross Joiner node to get max record id you obtain from GroupBy node in every table row from RowID node. However if you use Column Appender then you can use Missing Value node together with option to populate missing values with previous value. Hope this helps!
