Sum colums rows

[mitjap]

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.

[Saravanan_Desingh · Accepted solution]

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
];

[Saravanan_Desingh]

Output:

[mitjap]

Works great. thank you, thank you