Splits one input column into two or more output attributes, 10 maximum.
Input Parameter Sequence |
Description |
|---|---|
1 |
Source column containing the data to split. |
2 |
Delimiter in the input string that separates the data. Can be a space, comma, semi-colon, or colon. |
Output Parameter Sequence |
Description |
|---|---|
1 to 10 |
Microsoft Dynamics CRM target field in which to put the string containing the split data. |
Sample Data Map Using Split
This sample shows splitting of the source column, "Source_fullname", into the target firstname, middlename, and lastname attributes.
<Map Name="sample_contact_split">
<Description>Sample map showing Split Transformation</Description>
<EntityMap TargetEntityName="contact" SourceEntityName="Source_contact">
<AttributeMaps>
<AttributeMap>
</SourceAttributeName>Source_lastname</SourceAttributeName>
</TargetAttributeName>lastname</TargetAttributeName>
<ProcessCode>Process</ProcessCode>
<AttributeMap>
</AttributeMaps>
<TransformationMaps>
<TransformationMap>
<TransformationTypeName>Microsoft.Crm.Transformations.Split</TransformationTypeName>
<ProcessCode>Process</ProcessCode>
<InputParameterMaps>
<SingletonInputParameterMaps>
<SingletonInputParameterMap>
<ParameterSequence>1</ParameterSequence>
<DataTypeCode>Reference</DataTypeCode>
<Data>Source_fullname</Data>
<SingletonInputParameterMap>
<SingletonInputParameterMap>
<ParameterSequence>2</ParameterSequence>
<DataTypeCode>Value</DataTypeCode>
<Data></Data>
<SingletonInputParameterMap>
</SingletonInputParameterMaps>
<ArrayInputParameterMaps/>
</InputParameterMaps>
<OutputParameterMaps>
<OutputParameterMap>
<ParameterSequence>1</ParameterSequence>
<Data>firstname</Data>
</OutputParameterMap>
<OutputParameterMap>
<ParameterSequence>2</ParameterSequence>
<Data>lastname</Data>
</OutputParameterMap>
<OutputParameterMap>
<ParameterSequence>3</ParameterSequence>
<Data>lastname</Data>
</OutputParameterMap>
</OutputParameterMaps>
</TransformationMap>
</TransformationMaps>
</EntityMap>
</Map>