Finding Similar Rows and Making New Record with their Sum

Topic Labels: Scripting extentions
820 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello! I have a database of store inventory, and I’d like to see if there’s a way to search for similar rows, and then add up their quantities, and make a new row in a new table with that sum.

Screen Shot 2020-05-11 at 9.28.18 AM

For example, I’d like to go through this table, and sum the “Current” and “Past” quantities of rows that have the same “Name” into a new row in a different table. Such that there’s a new table where the rows are composed of: Lollipop Cherry with Current = 15, Past = 35; Lollipop Apple Current = 15, Past = 15; Gum Strawberry Current = 50, Past = 30; Gum Coconut Current = 45, Past = 30.
Would that be possible? If not, is there anything else that could be done to sum said values up?

1 Reply 1

Indeed, the script block could help you with this, but I have a sense that the new conditional rollup feature (released today) can also do this.