I have just started to experimenting in knime and I have encountered an issue regarding writing new data into a specific column without having a vlookup function in the table.
To explain it a bit more, I have a table with forecasting data and once each month I wish to update the last months forecast data with actual data. This also means that the column that should be updated will be n+1 each month. Until now I have changed the data in knime, written the data as a separate sheet in my Excel file and updated my table with a constant vlookup function all over the table. This works except for that I cannot keep my forecast figures in the table due to the vlookup function.
Is there a solution for this? I’m thankful for any help I can get!