Home Search

DriveWorks Pro 21
TableReplaceHeaderRow

Send Feedback

TableReplaceHeaderRow

Replaces the header row in the given table.

Syntax

TableReplaceHeaderRow([Table], [Replacement Row])

Where:

Table is the Table in which to replace the header row..

Replacement Row is the array that will replace the header row. The array must include a header row, the values on the first data row will be used to replace the existing table header.

Examples

RuleMeaning
TableReplaceHeaderRow(DwLookupCustomersAtoC,{"","","";"Company","Address1","Address2"})Will replace the header row of the Customers table with the values Company, Address1 and Address2
TableReplaceHeaderRow(DwLookupCustomersAtoC, TableRow("Company","Address1","Address2"))Does exactly as above but uses the TableRow function to construct the Replacement array.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

Example Outcome

Customers Table

CompanyAddress1Address2
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

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

Table returned as an Array
{"Company","Address1","Address2";"Amazon Warriors","Paris","France";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"}