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.
Solved! Go to Solution.
Hi @RPeeters you could use a summarize tool and group on OrderId and ItemID and then sum up the quantity field like below.
@JS420 Thanks!
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