Group by | sum up values

Hello,

I have the following input, and would like to have the output as descriped. (So add one row, and sum up the values for Project A, B, C… in the three columns). I think it should be not that hard but I did not manage so far. Can someone help :slight_smile:

Many thanks!
Data_Knime.xlsx (9.6 KB)

Input:
image

Output:
image

Hi @RapplK

See this wf groupby_and_sum_up.knwf (20.3 KB)
You need to pay some attention to the sort-order of the Zwischenergebnis.
Schermafdruk van 2022-09-16 11-00-32
gr. Hans

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.