KNIME: How to add numbers on two matching columns

I am a beginner to KNIME, and am trying to add values together based on matching columns.

I have three columns SKU, QTY on hand and batch. I need to add all the qty’s on hand for matching sku and batches (sometimes the same batch can have multiple different sku’s)

I have tried to use a simple set up of an excel reader and a row aggregator. However, the row aggregator only sums on either matching sku or batch and not both.
image

How would I be able to either change row aggregator to include both, or is there another tool that would be able to do it better?

Thank you in advance

Hi @Biravien_Anan

You are looking for a groupBy node. In here, you first define which of the columns should be considered as grouping columns (SKU and BATCH)

Under the aggregation tab, sum the QTY

4 Likes

This works thank you so much!

1 Like

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