ROTATE_LEFT

The number of columns to rotate to the left. This value must be a non-negative integer. The value of zero copies the rows without any rotation.

data

The numerical values to rotate to the left. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

ROTATE_LEFT rotates the specified data range left by a number of columns. It returns one new column for each input column, each containing a copy of the corresponding input column rotated to the left by num_cols positions. Columns that are rotated off the left are wrapped around on the right.

ROTATE_LEFT only works with numerical data. None of the data provided in the data parameter can be ASCII text.

Examples

TEMP = ROTATE_LEFT(1, MERGE(1, 2, 3)

Creates three new columns named TEMP, VX, and VY. TEMP contains the value two, VX contains the value three, and VY contains the value one.

TEMP = ROTATE_LEFT(0, V1:V3)

Creates three new columns named TEMP, VX, and VY. TEMP is a copy of column V1, VX is a copy of column V2, and VY s a copy of column V3.

TEMP = ROTATE_LEFT(4, V1:V3)

Creates three new columns named TEMP, VX, and VY. TEMP is a copy of column V2, VX is a copy of column V3, and VY is a copy of column V1.

TEMP = ROTATE_LEFT(1, V1[10:50]:V2)

Creates two new columns named TEMP and VX, each with values in the first 41 rows (the other cells are empty). The values in column TEMP are the values in rows 10-50 of column V2, and the values in column VX are the values in rows 10-50 of column V1.

Related Functions

Function	Description
ROTATE_RIGHT	Rotates the columns in the specified data range to the right