Retrieves the columns from the given table in the specified order, and returns the result.
TableSelectColumns([Table], [Collection of Columns])
Where:
Table is the table from which to retrieve the columns.
Collection of Columns are the indices of the columns that should be in the result table, these can be in any order, e.g. 3,2,1 to switch the first and third columns around.
| Rule | Meaning |
|---|---|
| TableSelectColumns(DWGroupTableCustomers,1,3) | Will return an array containing the records from columns 1 and 3 from the Customers table. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
Customers Table
| CustomerName | Country |
|---|---|
| Amazon Warriors | France |
| Bolton Burners | United States |
| Boston Bulls | Germany |
| Cambridge Cats | France |
| Dynamo Dynamics | United States |
| Eagle Sizzlers | United States |
| Everso Lucky | United States |
| Forty Somethings | United States |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","Country";"Amazon Warriors","France";"Bolton Burners","United States";"Boston Bulls","Germany";"Cambridge Cats","France";"Dynamo Dynamics","United States";"Eagle Sizzlers","United States";"Everso Lucky","United States";"Forty Somethings","United States"} |