Skip to Content
0
Feb 11, 2020 at 05:08 PM

delta load

70 Views

Hi experts,

ADSO A -> ADSO B, the field "quant" is summation.

ADSO A has two rows of data:

DOCNUM CALDAY QUANT

123 2020-01-10 4

456 2020-01-10 -1

CALDAY is key.

The result of ADSO B is:

DOCNUM CALDAY QUANT

456 2020-01-10 3

The question is,

how to keep the DOCNUM is 123,not 456.