Concatenate

Concatenates several input columns into one. Can also add a prefix and suffix.

Input Parameter Sequence	Description
1 (optional)	Prefix to add at the beginning of the string.
2 (optional)	Suffix to add at the end of the string.
3 (optional)	Delimiter to put between concatenated data. Valid values: space, comma and space, semi-colon and space, or colon and space.
4	Array containing one <Item> for each piece of data to concatenate. Each <Item> can either be a string or a reference to a source column.

Output Parameter Sequence	Description
1	Microsoft Dynamics CRM target field in which to put the concatenated string.

Sample Data Map Using Concatenate

This sample shows concatenation of two source columns, "Source_building", and "Source_room_number", into the target address1_line2 field.

<Map Name="sample_contact_concatenate">

<Description>Sample map showing Assign Value Transformation</Description>

<EntityMaps>

<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.Concatenate</TransformationTypeName>

<ProcessCode>Process</ProcessCode>

<InputParameterMaps>

<SingletonInputParameterMaps/>

<ArrayInputParameterMaps>

<ArrayInputParameterMap>

<ParameterSequence>4</ParameterSequence>

<Items>

<Item>

<ParameterArrayIndex>0</ParameterArrayIndex>

<DataTypeCode>Reference</DataTypeCode>

<Data>Source_building</Data>

</Item>

<Item>

<ParameterArrayIndex>1</ParameterArrayIndex>

<DataTypeCode>Reference</DataTypeCode>

<Data>Source_room_number</Data>

</Item>

</Items>

</ArrayInputParameterMap>

</ArrayInputParameterMaps>

</InputParameterMaps>

<OutputParameterMaps>

<OutputParameterMap>

<ParameterSequence>1</ParameterSequence>

<Data>address1_line2</Data>

</OutputParameterMap>

</OutputParameterMaps>

</TransformationMap>

</TransformationMaps>

</EntityMap>

</EntityMaps>

</Map>