1. UNIFYBroker Forum
  2. Ideas
0
Completed

Join transformation handle type conversion

Adam van Vliet 11 years ago • updated by anonymous 9 years ago • 2

The join transformation should handle type conversion.

This should be done using the schemaValidator.CreateValue or similar. Unfortunately this is made difficult by both sides being MultiKeyValue.

Huu Tran 11 years ago

It is the best that the conversion can be done during the comparison so that the attribute data type do not have to change. For example add "conversion" to Relationship tag as below

<Relationships>
<Relationship InputKey="OrgId" RelationshipKey="OBJID" Conversion = "Integer2String"/>
</Relationships>
<columnMappings>
<columnMapping SourceAttribute="SOBID" TargetAttribute="sapChiefPositionNumber" />
</columnMappings>

Adam van Vliet 9 years ago

Migrated to VSO.

Customer support service by UserEcho