Hi experts,
I have a transformation between 2 DSOs (A & B) which is using an expert routine to retrieve and process records from the first DSO (A), search for 1 or more entries in another DSO and allocated these records in the second DSO (B). I have checked the data in the second DSO (B) and for some reason some of the data does not belong to that record but of another one.
Just to give an example, I have 3 records:
Description Total Price
1 Item 1 180
2 Item 2 200
3 Item 3 250
With the transformation the data should be transformed like below:
Description Total Price Planned Price Actual Price
Item 1 180 180 180
Item 2 200 101 101
Item 2 200 99 99
Item 3 250 100 100
Item 3 250 150 150
But i'm getting the following:
Description Total Price Planned Price Actual Price
Item 1 180 180 180
Item 1 180 101 101
Item 1 180 99 99
Item 3 250 100 100
Item 3 250 150 150
I have tried debugging some of the records and the logic/code in my transformation seems to be fine. i'm thinking that it might be a problem with the activation, maybe there is a record with an error which is causing this issue. But this is the first time I've seen something like this.
Could anyone suggest what might be wrong or how i could identify the issue?
Regards,
Ahmed