Home arrow Reference arrow ConcatenateTextColumns

CONTENT WARNING

This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com

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