topic Re: Merge and sum value from rows with same ID in App Development

Merge and sum value from rows with same ID

Manuel1 — Tue, 04 Aug 2020 08:53:20 GMT

Hello,

I need help with the following question:

I have one table: Amount

with the following columns: ID and Amount

I now want to combine and sum within load script the amount for each ID.

Example: Table Amount

ID Amount

1 10

2 30

1 40

2 50

What i want in the end is one table with:

ID Amount

1 50

2 80

I need to do the calcultaion within the Script.

Thanks in advance.

Best regards

martinpohl — Tue, 04 Aug 2020 09:16:26 GMT

noconcatenate

load

ID,

sum(Amount) as Amount

resident Yourdatas

group by ID;

drop table Yourdatas;

Regards

Manuel1 — Tue, 04 Aug 2020 09:38:14 GMT

Yeahaaa !!! Thank you so much! It worked like a charm.

Have a nice week!