topic Sum colums rows in App Development

Sum colums rows

mitjap — Sat, 13 Feb 2021 16:30:50 GMT

did a lot things, but stuck at problem

first excel sheet

dnid	sifrap
657137	280200
717399	280200
717374	280200
705786	F40117
714113	F40117

in second sheet

dnidp	c_delotrn
717399	1740
717399	2040
717374	1380
717374	60
714113	3012
714113	1380

Result should be:

280200=sum 1740+2040+1380+60=5220

F40117=sum 3012+1380=4392

Its hard problem for me, but as allways, when you learn you know.

thanks for help.

Re: Sum colums rows

Saravanan_Desingh — Sat, 13 Feb 2021 16:41:11 GMT

Try this,

tab1: LOAD * INLINE [ dnid, sifrap 657137, 280200 717399, 280200 717374, 280200 705786, F40117 714113, F40117 ]; tab2: LOAD dnidp As dnid, c_delotrn; LOAD * INLINE [ dnidp, c_delotrn 717399, 1740 717399, 2040 717374, 1380 717374, 60 714113, 3012 714113, 1380 ];

Re: Sum colums rows

Saravanan_Desingh — Sat, 13 Feb 2021 16:41:43 GMT

Output:

Re: Sum colums rows

mitjap — Sat, 13 Feb 2021 17:13:27 GMT

Works great. thank you, thank you