MERGE
Applies to PredictiveInsight only.
Syntax
MERGE(data [, data]…) {data [, data]…}
Parameters
data
The name of a column to combine into a data range. 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. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® Unica® product.
Description
MERGE horizontally concatenates its input into a new group. It returns as many new columns as provided as input. An unlimited number of arguments can be provided.
*
The MERGE macro function can be specified using braces ( {}). Simply insert the arguments within braces separated by commas (for example, TEMP = {1,2,3} is equivalent to TEMP = MERGE(1,2,3)).
Examples
TEMP = MERGE(3, 4, "five") or TEMP = {3, 4, "five"}
Creates three new columns named TEMP, VX, and VY, containing the values 3, 4, and "five " respectively.
TEMP = V1:V3 or TEMP = MERGE(V1:V3)
Creates three new columns named TEMP, VX, and VY, where TEMP is a copy of the column V1, VX is a copy of the column V2, and VY is a copy of the column V3.
Creates five new columns named TEMP, VW, VX, VY, and VZ. TEMP is a copy of column V1; VW is a copy of column V3; VX through VZ are copies of columns V5 through V7.
Creates one new column named TEMP, where each row is the average of the corresponding row across columns V1, V3, and V5. An average is only computed up to the last row of the shortest input column.
Creates five new columns named TEMP, VW, VX, VY, and VZ. TEMP is a copy of the values in rows 10-50 of column V1; VW is a copy of the values column V3; VX through VZ are copies of the values in rows 1-30 of columns V5 through V7.
TEMP = AVG(MERGE(V1, V5:V6)) or TEMP = AVG({V1, V5:V6})
Creates one new column named TEMP containing the average of all cells in columns V1, V5, and V6.
Related Functions