Combining rows based on similar columns

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.

Workflow

Common Use Cases

Best Practices

Accepted answers

JosephSerpis

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

All comments

JosephSerpis

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

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335