Gets the value from the first data row and column of the given table.
Or
Gets the value from the first data row and specified column of the given table.
Or
Gets the value from the specified data row and column of the given table.
RowIndex of 1 will refer to the first data row, which is the first row after the header row.
TableGetValue([Table], [Column Index], [Row Index])
Where:
Table is the Table from which to get the value.
Column Index (optional) is the number of the column from which to retrieve the value. By default this will be the first column.
Row Index (optional) is the number of the data row from which to retrieve the value. By default this will be the first row.
| Rule | Meaning |
|---|---|
| TableGetValue(DWGroupTableCustomers) | Will return the value that exists in the Customers table at column 1, data row 1. |
| TableGetValue(DWGroupTableCustomers, 2) | Will return the value that exists in the Customers table at column 2, data row 1. |
| TableGetValue(DWGroupTableCustomers, 3, 8) | Will return the value that exists in the Customers table at column 3, data row 8. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indiana | United States |
| Eagle Sizzlers | Maine | United States |
| Everso Lucky | Vermont | United States |
| Forty Somethings | Illinois | United States |
| Example 1 | Amazon Warriors |
|---|---|
| Example 2 | Paris |
| Example 3 | United States |