How to fill values for specified columns with another row's values

Hi Knime experts
I have below data (also attached), hope some can help me .
Date 4/2/2022 4/9/2022 4/16/2022 4/23/2022 4/30/2022 5/7/2022 5/14/2022 5/21/2022
Week 40 41 42 43 44 45 46 47
Forecast 0 0 0 0 0 0 0 0
Actual 100 100 120 115 200 100 40 10

Want to get output:

  1. Due to current week is wk47, I just want use wk40~wk46 's actual no. to fill in forecast wk40 to wk46. It means current week will always no need be filled with actual no.
    And so on, if I have new forecast released in wk48, then current wk is wk48, then wk40~wk47 need be filled with actual no. , but wk48 no need be filled actual no.

  2. I have Rev B forecast from wk40 to wk52 and Rev A forecast from wk40 to wk52. I want to compare the two Rev forecast. Which node I could use for this request.

Thanks in advance

data.xlsx (11.0 KB)

Hi, could you ask your question 1 again? I don’t understand what you would like.

For number 2, you can use the Transpose node on your data and then compare the columns via the Math Formula node for instance.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.