Home arrow Reference arrow ConcatenateTextColumns
ConcatenateTextColumns

Creates a new text column that combines text from two other columns separated by a specified character.

Syntax:

ConcatenateTextColumns, columnID1~columnID2, character 

Parameters:

columnID1 - The name of the first text column.

columnID2 - The name of the second text column.

character - The character placed between the data from the first and second columns. 

 

Examples:

ConcatenateTextColumns,prop1~prop3,x 

This example combines text from columns prop1 and prop3 into a new column called 'prop1xprop3'. The rows of the new column will then look like this: '<string>x<string>'

 

Reference

Installation - Java