cancel
Showing results for 
Search instead for 
Did you mean: 

Loading of Master Data using Transformation Groups

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I donu2019t think you can achieve the desired result by using transformation group.

Should try End-Routine.

Edited by: Passing By on Dec 1, 2011 1:43 AM