1.3.11.7 Concatenate

The Concatenate processor concatenates two or more attribute values with an optional user-defined character or String as the 'glue' between the column values.

Use the Concatenate processor to create a concatenated key or concatenated value across multiple attributes to feed into other processors for further analysis.

It is also often useful to concatenate data when cleansing data for the purpose of matching - for example in order to create a single attribute for the whole of an address.

The following table describes the configuration options:

Configuration	Description
Inputs	Specify any String or String Array attributes that you want to concatenate into a single attribute. If you input an Array attribute, the element values in the array will be concatenated to form a String output.
Options	Specify the following options: Separator String: allows you to specify the String used as 'glue' in between the values that are concatenated together. Specified as a text entry. Default value: Space. Ignore empty Strings: ignores empty Strings and Nulls when concatenating. Specified as Yes/No. Default value: No.
Outputs	Describes any data attribute or flag attribute outputs.
Data Attributes	The following data attributes are output: Concat: stores the result of the concatenation. Value is a concatenation of the input attribute values, with the specified separator String between them.
Flags	None.

The Concatenate transformer presents no summary statistics on its processing. In the Data view, the input attributes are shown with the new added concatenated attribute to their right.

Output Filters

None.

Example

In this example a number of Address attributes are concatenated using a comma separator String to form a new attribute renamed WholeAddress.

Address_Line1	Address_Line2	POSTCODE	WholeAddress
Bonds Lane, Garstang	Preston	PR3 1RA	Bonds Lane, Garstang, Preston, PR3 1RA
Temsford Hall	Sandy	SG19 2BD	Temsford Hall, Sandy, SG19 2BD
West Thurrock	Purfleet	RM19 1PA	West Thurrock, Purfleet, RM19 1PA