Dynamic row calculation of columns

Hello @aj05 and welcome to the KNIME forum.
This is your workflow:

  1. Send your column $F$ to variable $${DF}$$
    It takes the first row by default

  2. Rule Engine column $factor$:

NOT $F$ = $${DF}$$ => $F$
TRUE => 1
  1. Moving Aggregation $Product$
    You can control the window length as variable from a ‘Table Dimension’ node (not included)

  2. Math Formula:

$${DF}$$ * $Product(factor)$

BR

4 Likes