i just started using Knime and I want to sort a table with strings.
I also attached an excel file with my table (input) and how i want to rearrange the table (output).
So basically i would like to have all targets 1 in a column, all targets 2 in a column and so on, but still keep the missing values, if that makes sense.
There are many ways to do this in KNIME but one Rule Engine node for each column/target word seems like a good approach if you don’t have much more than 4 columns and target words are not changing all the time.
So you go from back and in first Rule Engine you’ll have following syntax: