"if two numbers are equal then add numbers together" if statement question

[acerdell]

Hi,

I have been working on a project at and got stuck on a minor problem; I would like to remove the duplicate codes by adding their corresponding numbers together. I appreciate for the help

Code	n_ops
112233	5
123456	6
362343	8
123456	3
874531	4
987655	5

This is the output that I would like (below)

Code	n_ops
112233	5
123456	9
362343	8
874531	4
987655	5

[garthheward]

A Summarize tool can do this for you.

Summarize, and group by "Code" and sum "n_ops"

[kat · Accepted solution]

Hi @acerdell

I saw that you hadn't yet marked this as resolved. In case you're not sure how to set this up, I've attached an example workflow.

configuration of the summarize tool

Cheers

Kat