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
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
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"} |