Icon

KNIME_​project

Read in data

Keep only a column containing the list of row numbers where the missing values were

Create the pairs of start and end index for the group of items which will be summed up

Table Creator
Get the row number as a newcolumn where 'amount' is missing
Expression
Concatenate
Remove empty rows
Missing Value
Remove 'amount'column
Column Filter
Get the pairs of startand end index in oneline
Lag Column
Go through each pair of start and endindex
Chunk Loop Start
Clean upedges
Missing Value
Turn the start and endindex into flow variables
Table Row to Variable
Filter the original tableto only take in betweenthe start and stop index
Row Filter
Make the columnnames clear
Column Renamer
All rowsexcept last row
Table Cropper
Only last row
Table Cropper
Get the sum of the'amounts' column
GroupBy
Turn the suminto a flow variableso we can attachit to the last row
Table Row to Variable
Add the sum. (Replace theamount column)
Constant Value Column
Add the new last-rowwith the sum to therest of the rows
Concatenate
Put all groups backtogether
Loop End

Nodes

Extensions

Links