Skip to Content
0
Former Member
Jul 23, 2009 at 05:39 AM

how to write a start routine in the transformation?

12 Views

Customer has one requirement. See one example as below, the value will be changed from Source filed into DSO. If filed like the amount is same based on same Receive nr., then we will have only one record on DSO "BBBB", even if value of Key point is different. If the amount is different based on same Receive nr. , then we will also need to have this record on DSO "BBBB".

Source field

Receive nr.;Type;Key point;Amount;

F9001;LU;J001;662;

F9001;LU;J002;662;

F9001;LU;J003;154;

Data should be shown in the DSO like below::

Receive nr.;Type;Key point;Amount;

F9001;LU;J002;662;

F9001;LU;J003;154;

DSO "BBBB"

Key field: Receive nr.;Type;Key point;

Data field: Amount;

Please let me know how to write a start routine in the transformation? Thanks for any input.