I would like to group the data from the excel file, like in a pivot table: So in this case group by columns “sachkto”; “prct”; “coauftrag” and “zuordnun” and show the sum “fw_brutto”
I think I need the node “group by”, but I am not sure how and where to set the correct configurations in the node to make it work.
Put you row identifiers in the first configuration dialog (Groups).
Than open the manual aggregation dialog and insert the variable you want to sum up.
You should also change the aggregation function from “mean” (default option) to “sum”.
Be sure that the column "fw_brutto” is numerical otherwise KNIME will not allow you to use the “sum function”.