Sum based on attribute

[zoeuno]

I'm working on a project which asked to sum the two field and eliminate one line if they have the same attribute (in my case, ID number).  For example, for my input below, as you can see, there are two entries with ID number 2, and the goal is to sum the two income with the ID 2 and get rid of one lines. It's straightforward in Excel, but I'm having difficulty implementing it into Alteryx, hope someone can help. Thanks!!

Input				Output
ID	Income			ID	Income
1	5			1	5
2	7			2	17
2	10			3	15
3	5			4	16
3	10
4	16

[JoshKushner · Accepted solution]

You can use the Summarize Tool to get your desired results.

Group By: ID
Sum: Income