Combining rows based on similar columns

[RPeeters]

I have created a workflow that creates a shipping report. Recently I noticed that 'revisions' were missing from the report. So I added the revisions column from my database into the workflow. However now I am wondering how I can combine the data.

Input:

OrderId - ItemId - Revision - Quantity

1 - 2 - 0 - 1

1 - 2 - 1 - 1

2 - 2 - 1 - 1

Desired output:

OrderId - ItemId - Revision - Quantity

1 - 2 - 0 -2

2 - 2 - 1 - 1

Revision is not important in the output, but quantity has to be added together based on OrderID + ItemID being equal but having different Revisions.

[JosephSerpis · Accepted solution]

Hi @RPeeters you could use a summarize tool and group on OrderId and ItemID and then sum up the quantity field like below. 

[RPeeters]

@JS420 Thanks!

[LordNeilLord]

Hey @RPeeters 

Use the summarize tool, Group on OrderID, ItemID and Sum Quantity.

If you need Revision, you can use min, max, first, last whatever you need