Sum of Rows with same value in a column

[AlyKnime]

Hello,

Is there a way in knime to compute a sum of rows with same value in a specific column. Attached is the excel file for the data and the highlighted (sum) is what I need. Thanks in advance! Sample File.xlsx (16.1 KB)

[mehrdad_bgh]

Hi @AlyKnime ,

KNIME_project34.knwf (8.5 KB)

GL,
Mehrdad

[AlyKnime]

Hi @mehrdad_bgh,

Thanks for this but I need the rows to be the same count. It is like there is a subtotal per PO. And computation of impact is per PO as well since the PO# are the same and the PO qty as well is same per category (code).

[aworker]

Hi @AlyKnime

Attached another possible solution.

Hope this helps

20210504 Pikairos Sum of Rows with same value in a column.knwf (65.7 KB)

Ael

[mehrdad_bgh]

Nice job aworker

[AlyKnime]

Hi @aworker ,

I think this works! Thank you so much!!

[aworker]

Many thanks @AlyKnime for validating the solution and to @AlyKnime and @mehrdad_bgh for your kind comments !

Best wishes,

Ael

[AlyKnime]

hi @aworker

I have a problem in using moving aggregation node. I did use the same you have provided. Please see the image to see the error. Thanks!

[aworker]

Hi @AlyKnime

Would you mind please to upload the workflow I provided you with the data that is causing the problem? I’ll have a look at it and I’ll let you know what is going wrong.

Best,

Ael

[AlyKnime]

hi @aworker I already fixed it. It is because of the “?” on the impact column I changed the “?” values into “0” . thanks again!

[aworker]

@AlyKnime great news !

Best

Ael