Hi, I am fairly new to Knime and am struggling to find an efficient way to merge multiple columns based on a criteria.
In the table I have provided a simplistic representation of my data layout. I would like to merge the first set of columns (Col1-4) with a second set of columns (Col1B-4B) and
append the mergers to the table as a third, new set of columns (Col1C-4C).
The criteria is simple: if a row ID contains a missing value in the first set, then the value in the second set of columns is used, otherwise the value in the first set of columns is used.
Column merger does this perfectly. However, the column sets are hundreds and the primary and secondary columns have to be set for each individual merge. I would like to use this workflow for several different initial data sets (same lay-out) so wish to avoid having to configure multiple Column merger nodes each time.
Does anyone have any suggestions?
Thankyou for your time,