Home Search

DriveWorks Solo 22
TableGetHeaderRow

Send Feedback

TableGetHeaderRow

Gets the header row from the given table, as a data row.

Syntax

TableGetHeaderRow([Table], [As Data Row])

Where:

Table is the Table from which to get the header row.

As Data Row (optional) is TRUE by default and will return the header row as a data row. If set to FALSE it will return it as a header row.

Examples

RuleMeaning
TableGetHeaderRow(DWGroupTableCustomers, TRUE)Will return an array comprising of two rows; the first row (header row) containing empty values, the second row (data row) containing the values retrieved from the header row in the Customers group table.
TableGetHeaderRow(DWGroupTableCustomers, FALSE)Will return an array comprising of one row, which will be the header row retrieved from the Customers group table.

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 Outcomes

Example 1 - First Row contains blank values, Second Row contains the header names

CustomerNameCityCountry

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

Example 1 - Table returned as an Array
{"","","";"CustomerName","City","Country"}

Example 2 - Single Data Row contains the header names

CustomerNameCityCountry

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

Example 2 - Table returned as an Array
{"CustomerName","City","Country"}