Merge directive
The MERGE directive merges two columns by inserting a third column into a record. The values in the third column are merged values from the two columns delimited by a specified separator.
Syntax
merge :column1 :column2 :destination 'seperator'
The
column1
andcolumn2
values are merged using a separator. The columns to be merged must both exist and should be of type string for the merge to be successful.The
destination
is the new column that will be added to the record. If the column already exists, the contents will be replaced.The
separator
is the character or string to be used to separate the values in the new column. It is specified between single quotes. For example, a space character:' '
.The existing columns are not dropped by this directive.
Usage Notes
The columns to be merged should both be of type string.
Examples
Using this record as an example:
{
"first": "Root",
"last": "Joltie"
}
Applying these directives:
merge :first :last "fullname ' '
merge :first :last :fullname '''
merge :first :last :fullname '\u000A'
merge :first :last :fullname '---'
results in these records:
Separator is a single space character (' '
):
Separator is a single quote character ('''
):
Separator is the UTF-8 Line Feed character ('\u000A'
):
Separator is multiple characters ('---'
):
Created in 2020 by Google Inc.