Hello,
When I try to load data to Infoobject attributes using Transformation Groups I get Duplicate records error, and if I mark the check box of Handling Duplicate Data Records, wrong data is loaded.
Simplified Example:
InfoObject A masterdata being loaded.
The masterdata has two attributes: X and Y
The datasource has 3 fields: D1, D2, D3
Transformation group 1:
A = D1 (Direct Assignment)
X = Routine: if D2='AA', then result = D3
Y = No Assignment
Transformation group 2:
A = D1 (Direct Assignment)
X = No Assignment
Y = Routine: if D2='BB', then result = D3
I load following data (snapshot from PSA):
D1|D2|D3
Z1|AA|10
Z1|BB|20
Z2|AA|30
I want to see in MasterData:
A |X |Y Z1|10|20 Z2|30|0
BUT:
The system actually makes 4 records that are tried to be loaded:
A |X |Y
Z1|10|0 (Result of transformation group 1 for first record)
Z1|0|20 (Result of transformation group 2 for first record)
Z2|30|0 (Result of transformation group 1 for second record)
Z2|0|0 (Result of transformation group 2 for second record)
This explains why I get Duplicate Records Errors (since there are 2 records for each of 2 keys), and if I mark to handle duplicate records, only one of two records (for each key) is loaded, and this is incorrect, I get:
A |X |Y Z1|0|20 (Result of transformation group 2 for first record) Z2|0|0 (Result of transformation group 2 for second record)
Any advises?
Thanks!