Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
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
];
Output:
Works great. thank you, thank you