Replaces the header row in the given table.
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.
| Rule | Meaning |
|---|---|
| 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. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
Customers Table
| Company | Address1 | Address2 |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
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"} |