TableGetHeaderRow (DriveWorks Documentation)

TableGetHeaderRow

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

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.

Rule	Meaning
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.

Customers Table

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


CustomerName	City	Country

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

CustomerName

City

Country

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

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