COLUMN macro

The COLUMN macro is available only in Unica Campaign.

Syntax

COLUMN(data [, data]…) or (data [, data]…)

Parameters

data

A value to use in creating a column. This can be a constant value (numeric or ASCII text in quotes), a column, a cell range, or an expression evaluating to any of the above. This parameter can be repeated multiple times, but subsequent parameters must have the same dimensionality (that is, column width) as the first parameter. All values in all data parameters must be either numeric or ASCII text (that is, you cannot mix numeric and text values). If multiple data parameters are provided, they all must have the same number of columns. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your product.

Description

COLUMN vertically concatenates its inputs into columns of a function group. It returns the same number of new columns as provided in each input parameter. An unlimited number of arguments can be provided. All arguments must be either numeric or ASCII text strings (that is, you cannot mix numeric and text values).

Note: The COLUMN macro function can be abbreviated by listing the data arguments separated by commas inside parentheses (for example, (for example, TEMP = MEAN((1,2,3,4), ALL). If not used inside another macro function, the pair of parentheses is not necessary (for example, V1=1,2,3 is equivalent to V1=COLUMN(1,2,3).

Examples

TEMP = COLUMN(3, 4, 5) or TEMP = (3,4,5) or TEMP = 3,4,5

Creates a new column named TEMP with the first three cells containing the values 3, 4, and 5.

TEMP = COLUMN("one","two", "three")

Creates a new column named TEMP with the first three cells containing the values "one ", "two ", and " three ".

TEMP = AVG(V1), STDV(V1)

Creates a new column named TEMP with the average of column V1 in the first cell and the standard deviation of column V1 in the second cell.

TEMP = V1:V2, V3:V4

Creates two new columns named TEMP and VX where the column TEMP contains the values from column V1 followed by the values from column V3. The column VX contains the values from column V2 followed by the values from column V4.

TEMP = V1:V2, V3:V4

Creates two new columns named TEMP and VX where the column TEMP contains the values from cells 1-10 of column V1 followed by all the values from column V3. The column VX contains the values from cells 1-10 of column V2 followed by all the values from column V4.

TEMP = V1:V2, V3:V4

Creates two new columns named TEMP and VX, each containing a single value. The column TEMP contains the average of columns V1 and V2. The column VX contains the average of columns V3 and V4.