DriveWorks Pro 15: SppReOrderTableColumns [send feedback...]

SppReOrderTableColumns

Returns a table showing specific columns.

Syntax

SppReOrderTableColumns([Table Array],[Column Order])

Where:

Table Array is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).

Column Order is the new Column Order as a pipebar (|) delimited string, for example "2|7|5". Number starting at 1 for the first column.

Examples

RuleMeaning
ListAll(SppReOrderTableColumns(DwTableName,"3|2|1"),3)Will return the table showing columns 3, 2 and 1 only and in that order.

Table of Contents