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`.