Use the fields in the Row and Column Lookup section of the ODBC tab to specify the row and column from which you want to extract data. The fields are available for use when you specify a Row & Column Lookup Method (see Configure SQL Query Lookup Properties).
- Row—Specify the row index that identifies the point’s location within the query’s results table. The row index has to be in the range specified in the SQL Query (for which the point is to extract data).
- Column—Specify the column index that identifies the point’s location within the query’s results table. The column index has to be in the range specified in the SQL Query (for which the point is to extract data).
For an example of how a point might be configured to extract data from an ODBC Query results table using the Row & Column Lookup Method, see Query an Oracle Database using the Row & Column Lookup Method.