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

[Chenfang]

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)

[victor_palacios]

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.