AnsweredAssumed Answered

How can I total a Quantity field by a single SKU value?

Question asked by jon.mayoh008888 on Aug 4, 2017
Latest reply on Aug 8, 2017 by jon.mayoh008888

How can I total a Quantity field by a single SKU value?

 

The example is

 

I have two SKUs in the input file which can be in any order.  SKU 12345 and SKU 54321.  The input also contains a QTY field. How can I total the vlaues of the SKU in one output?

 

eg 

Input 

SKU 12345 QTY = 5

SKU 12345 QTY = 5 

Output SKU 12345 Total_QTY = 10

 

SKU 54321 QTY = 3 

SKU 54321 QTY = 3 

Output SKU 54321 Total_Qty = 6

Outcomes