| 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>' |