ROW

Purpose:

Extracts a row of data from a table.

Syntax:

ROW(a, rownum)

a

-

A series or table.

rownum

-

An integer. The row number to extract.

Returns:

A row series.

Example:

W1: {{1, 4, 6},

     {2, 5, 7}, 

     {3, 6, 8}} 

 

W2: row(W1, 2)

 

returns {{2, 5, 7}}

Example:

W1: {{1, 4, 6},

     {2, 5, 7}, 

     {3, 6, 8}} 

 

W2: W1[2, ..]

 

returns {{2, 5, 7}}

Example:

transpose(row(W1, 3))

 

converts the row into a column of data.

Remarks:

To perform series operations on a single row of data, first use the TRANSPOSE function to convert the row into a column, or series. To select more than one row of data, use the REGION function.

 

See .. (Range Specifier) for more example of the array syntax method for extracting one or more rows and/or columns.

See Also:

.. (Range Specifier)

COL

REGION

ROWLEN

ROWMAX

ROWMEAN

ROWMIN

ROWREDUCE

ROWSTDEV

ROWSUM

TRANSPOSE