DriveWorks Solo 15: TableGetValue [send feedback...]

TableGetValue

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.

TableGetValue will not retrieve values from the header row.

RowIndex of 1 will refer to the first data row, which is the first row after the header row.

Syntax

TableGetValue(Table As Table, Column Index As Double, Row Index As Double)

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.

Examples

RuleMeaning
TableGetValue(DWLookupCustomers)Will return the value that exists in the Customers table at column 1, data row 1.
TableGetValue(DWLookupCustomers, 2)Will return the value that exists in the Customers table at column 2, data row 1.
TableGetValue(DWLookupCustomers, 3, 8)Will return the value that exists in the Customers table at column 3, data row 8.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcomes

Example 1Amazon Warriors
Example 2Paris
Example 3United States


Table of Contents