Create parents table from children

[Julio_Moyano]

Hi, 

I would like to create a Parents table from child table because I need to summarize. I Have tried to do in action but I could not create only once 'Description' and Sum the value

I have a child table like this:

Id	Id control	Description	Detail	Value
337dc0ba	b7c10f02	General	General 1	50
b0163fca	b7c10f02	General	General 2	20
a6330f3c	b7c10f02	General	General 3	10
11e4497a	b7c10f02	Marketing	Marketing 1	15
e6f9128b	b7c10f02	Marketing	Marketing 2	10
0737de4a	b7c10f02	Finance	Finance 1	20
dcc719b9	b7c10f02	Finance	Finance 2	10

This is the output required

Id	Id control	Description	Value
dhsksr3	b7c10f02	General	80
5621jsoa	b7c10f02	Marketing	25
2452sad	b7c10f02	Finance	30

In SQL it would be like this:

CREATE TABLE Parents AS
SELECT Description, Id Control, SUM(Value) AS SumValue
FROM Child
GROUP BY Description;

thanks

[SkrOYC]

Well, show us which actions you have created and their config to be able to provide feedback.

I would add an inline action to an action of "add a new row to another table using values from this row" in the Description column and use a condition to prevent duplicates. The condition would check if there is already a row with the same description