Skip to Content
0
Former Member
Nov 30, 2011 at 05:51 PM

Loading of Master Data using Transformation Groups

18 Views

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!