Page tree



Merges two or more columns of String type to generate output of String type. Optionally, you can insert a delimiter between the merged values. 

NOTE: This function behaves exactly like the merge transform, although the syntax is different. See Merge Transform.


Basic Usage

String literal reference example:

derive type:single value:MERGE(['Hello,','World'],' ') as:'Hi'

Output: Generates a new column called Hi with the value Hello, World.

Column reference example:

derive type:single value:MERGE([string1,string2]) as:'merged_strings'

Output: Generates a new merged_strings column containing a single String value that is the merge of string1 and string2 values.

Syntax and Arguments

derive type:single value:MERGE([string_ref1,string_ref2],'string_delim')

ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function
string_delimNstringOptional delimiter string to insert between column or literal values

For more information on syntax standards, see Language Documentation Syntax Notes.

string_ref1, string_ref2

String literal or name of the string column whose elements you want to merge together. You can merge together two or more strings.

Usage Notes:

Required?Data TypeExample Value
YesString literal or column referencemyString1, myString2


Optional string literal to insert between each string that is being merged.

Usage Notes:

Required?Data TypeExample Value
NoString literal'-'


Tip: For additional examples, see Common Tasks.

Example - Simple merge example

The following example contains the names of a set of American authors. You need to bring together these column values into a new column, called FullName.




derive type:single value:MERGE([FirstName,MiddleInitial,LastName],' ') as:'FullName'

Since the entry for J.D. Salinger has no middle name, you might want to add the following transform:

replace col:FullName  with:' ' on:'  '


JackKerouacLJack L Kerouac
PaulTherouxEPaul E Theroux
J.D.Salinger J.D. Salinger
PhilipDickKPhilip K DIck

Other Examples

While the syntax may be different, the MERGE function behaves exactly like the merge transform. For more examples, see Merge Transform.


This page has no comments.