I have historical data (lets say from the year 2019) and I want to combine them with the new data from 2020. The structure of both datasets is identical. The historical data will be imported via a table reader node and the current data will be transformed via a KNIME workflow.
My idea is, to use a Concatenate node, but I’m not sure how to configure it correctly to leave the historical data untouched and just add the new data?
you should use Concatenate node for this. It does not change data. So if the structure of both datasets is identical then it will simply append data coming from second input port to data from first input port.
I would use Append Suffix option otherwise you can loose some rows in case of duplicate RowIDs. Same goes for Union option as if you have intersection option and different data structure you’ll loose columns.