# Combine two similar rows

**URL:** <https://forum.knime.com/t/combine-two-similar-rows/49481>\
**Category:** KNIME Analytics Platform\
**Created:** [November 30, 2022, 4:07pm UTC](https://forum.knime.com/t/combine-two-similar-rows/49481 "2022-11-30T16:07:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jowairieyyah123](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/df705f/32.png) [@Jowairieyyah123](https://forum.knime.com/u/Jowairieyyah123)\
**Post date:** [November 30, 2022, 4:07pm UTC](https://forum.knime.com/t/combine-two-similar-rows/49481/1 "2022-11-30T16:07:43Z")

</div>

Hello, i am very new to knime and i want to combine two rows which are a duplicate with same characteristics but only different values.

for eg. the dash below represents different columns (company, month, value)  
company 1 - Feb - 2000  
Company 1 - Feb - 3000  
Company 1 - march - 1000

results i want is below:  
company 1 - feb - 5000  
company 1 - march 1000

thank you in advance for your support.

---

<div class="post-metadata">

**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\
**Post date:** [November 30, 2022, 4:58pm UTC](https://forum.knime.com/t/combine-two-similar-rows/49481/2 "2022-11-30T16:58:59Z")

</div>

Hi @Jowairieyyah123 , and welcome to the KNIME community.

From your example data, what you appear to be wanting to do is summarize your data so that keeping the other columns the same, you are aggregating the value column.

To do this, you can use a **GroupBy** node. Specify all of the columns **except** value as your Group columns on the “ **Groups** ” tab, and then choose the **value** column on the “ **Manual Aggregation** ” tab, and choose **sum** as the aggregation method.

You’ll probably want to opt to keep the original column name too  
e.g.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/b/2b9b29eeb03ec77689cdad476c1e316bf98069b2.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/5/05480c5945afbd8a5342524dc61a842f7d6af7c8.png)

I hope that helps. By the way, I’m assuming that all of your data is actually going to remain in consistent case between the input table and the required output. In your example, you had changes of case but I’m guessing that was just a quick draft rather than actually wanting a change of case. 😉

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [February 28, 2023, 4:59pm UTC](https://forum.knime.com/t/combine-two-similar-rows/49481/3 "2023-02-28T16:59:56Z")

</div>

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