cancel
Showing results for 
Search instead for 
Did you mean: 

delta load

former_member435389
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

sdsunny372
Active Participant
0 Kudos

Hi Wei Cui,

As you have mentioned Calday is key.

But as per my understanding there should be more fields as key instead of only calday.

Additionally Doc_numb should be key.If you can provide data source name incase of standard data source and incase of custom data source please provide base tables for that data source ,so it will be easy to identify your problem.

Best regards,

Sagarkumar Darji

former_member435389
Participant
0 Kudos

Hi Darji

There are more keys , as you said, I just gave a simple example from DSO to DSO.

But Doc_num is not the key in my case.

sdsunny372
Active Participant
0 Kudos

Hi Wei Cui,

Check data for all keys against doc number 123 & 456,there should be unique data for combinations of all key and for that doc numbers are also unique (123,456), so as per my knowledge value which are coming should be correct.

How do you expect 123 , still I did not understood

Do you have any data to which we can validate?