How to summarize quantities of sold products by grouping by category

How to summarize quantities of sold products by grouping by category

Hi,

I have a list of sold products and quantities.
Product Name = Category+Suffix
I want to summarize the sold quantities by Category.
Is there a function Deluge to do this ?


From :
{"productName":"CategoryA_suffix1","quantity":"QA1"},
{"productName":"CategoryA_suffix2","quantity":"QA2"},
{"productName":"CategoryA_suffix3","quantity":"QA3"},
{"productName":"CategoryB_suffix1","quantity":"QB1"},
{"productName":"CategoryB_suffix4","quantity":"QB4"},
{"productName":"CategoryB_suffix6","quantity":"QB6"}
To :
{"CategoryName":"CategoryA","quantity":"sum(QA)"},
{"CategoryName":"CategoryB","quantity":"sum(QB)"}