Skip to content

UNITE

Action

Bases: BaseMorphAction

Unite a list of columns with a selected string (i.e. concatenating text in multiple fields).

Script template

"UNITE > 'destination_field' < 'by'::['source_field', 'source_field', etc.]"

Or:

"UNITE > 'destination_field' < ['source_field', 'source_field', etc.]"

Where 'by' can be any string with one MAJOR caveat. Since :: is used in the query, you cannot use it for joining. By default this will be ', ' and so, alternatively, you can leave the 'by' term out.

Example

"UNITE > 'reference' < ', '::['Reference 1', 'Reference 2', 'Reference 3']"