Transformation between aDSOs with different Keys

[former_member555784]

Hi together,

i have a questions about the transformation between two ADSOS.

aDSO1: KeyField1, KeyField2, Attribute1

aDSO2: KeyField1, KeyField2, KeyField3, Attribute1

Now I want a transformation from source aDSO1 to target aDSO2. I want to update the Attribute1 field with the Attribute1 field from source aDSO.

Now the transformation fills the KeyFigure3 field with an initial value and creates an new entry instead of update the existing one.

Example:

aDSO1: 1000 10 XXX

aDSO2: 1000 10 10 ABC

After tranformation the target aDSO has two entries:

1000 10 10 ABC

1000 10 XXX

But i want only one entry in the target aDSO.

1000 10 10 XXX

Is this possible?

Thanks a lot!

[FCI]

Unfortunately (?) there is no "No transformation" available for key fields, you have to lookup into the target and fill the missing key accordingly (with append if more than one record).

Regards,

Frederic

[former_member555784]

Hi Frêdêric,

thanks for your answer.

This would work fine but in case if there are two entries in target adso belonging to only one entry in source adso (because the target dso has one more keyfield) this doestn´t work without doing loops and appends.

I want to avoid looking up in target adso and append entries in case of multiple entries in target adso belonging to one entry in source.

The best way would be to do a "no transformation" on the one key field is miss in source adso, but this doesn´t work for keyfields or?

Regards

Andy

[FCI]

Hi Andreas,

In the transformation between aDSO1 and aDSO2, you can read aDSO2 to get the keyField3 and populate the right record.

The end routine can be used for this purpose.

Regards,

Frederic