moveColumnsUp

The moveColumnsUp method creates a new table with specified columns appearing first in order, to the far left.

Syntax

table.moveColumnsUp(columnsToMove...)

Parameters

ParameterTypeDescription
columnsToMoveString...

Columns to move to the left side of the new table. Columns can be renamed with syntax matching NewColumnName=OldColumnName.

Returns

A new table with specified columns appearing first in order, to the far left.

Examples

The following query moves column B to the first position in the resulting table.

source = newTable(
    stringCol("A", "apple", "apple", "orange", "orange", "plum", "plum"),
    intCol("B", 1, 1, 2, 2, 3, 3),
    stringCol("C", "Macoun", "Opal", "Navel", "Cara Cara ", "Greengage", "Mirabelle"),
    intCol("D", 1, 2, 12, 3, 2, 3),
)

result = source.moveColumnsUp("B")

The following example moves columns B and D to the first positions in the resulting table.

source = newTable(
    stringCol("A", "apple", "apple", "orange", "orange", "plum", "plum"),
    intCol("B", 1, 1, 2, 2, 3, 3),
    stringCol("C", "Macoun", "Opal", "Navel", "Cara Cara ", "Greengage", "Mirabelle"),
    intCol("D", 1, 2, 12, 3, 2, 3),
)

result = source.moveColumnsUp("B", "D")