Add row with subtotal

This components adds a row at the bottom of the table. The new row contains the sum for the selected column and a description text which can be entered in the components configuration. Additionally, the column for the description text can be selected.

Note: The column selected for the description text will be converted to a String column.

Options

Column for description: Select the column which should store the description text for the sum.%%00010%%00010Note: This column will be converted to a String column.
Column to sum: Select the column to sum. %%00010The sum will be added at the bottom of the selected column.%%00010
Description Text: The description text which is added to the bottom of the selected column

Input Ports

: Input table containing the row to sum

Output Ports

: Output table containing a new row at the bottom containing the sum and a description.

Nodes

Column Selection Configuration2 ×
GroupBy2 ×
Table Row to Variable2 ×
Column Auto Type Cast1 ×
Component Input1 ×
Show all 12 nodes

Extensions

FeatureKNIME Base nodes
FeatureKNIME Quick Forms