Learning on the fly how to use KNIME, and came across a challenge: I want to add a new column to an existing table. It will actually have a static value, but I’m sure I’ll need columns with formulae in the future.
When searching community posts, it suggests using Table Creator but I can’t work out how that would achieve what I want given it takes no inputs. In my case, I’m already midway through my workflow and have filtered some rows - I now want to label the resulting dataset before merging back in.
You can also use the rule engine, node, string, or number, manipulation, nodes, or the column expressions node for this easily as well. You just select new column instead of an existing one, then, instead of entering a formula, you just enter the value. It will make that value the result in a new column, for all of the existing rose in the table.