Home Search

DriveWorks Pro 23
TableRemoveColumn

Send Feedback

TableRemoveColumn

Removes a column in the given table.

Syntax

TableRemoveColumn(Table, Column Index)

Where:

Table is the Table from which to remove the column.

Column Index is the index of the column to remove.

Examples

RuleMeaning
TableRemoveColumn(DWGroupTableCustomers, 3)Will return an array of the Customers table with column 3 removed.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianapolisUnited States
Eagle SizzlersColumbusUnited States
Everso LuckyBurlingtonUnited States
Forty SomethingsChicagoUnited States

Example Outcome

CustomerNameCity
Amazon WarriorsParis
Bolton BurnersConcord
Cambridge CatsToulouse
Dynamo DynamicsIndianapolis
Eagle SizzlersColumbus
Everso LuckyBurlington
Forty SomethingsChicago

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City";"Amazon Warriors","Paris";"Bolton Burners","Concord";"Cambridge Cats","Toulouse";"Dynamo Dynamics","Indianapolis";"Eagle Sizzlers","Columbus";"Everso Lucky","Burlington";"Forty Somethings","Chicago"}