DbTable

(Requires Analytica Enterprise or Power Player)

DbTable(dbIndex, columnIndex)

DbTable() is used to get at the data within a result table. The first argument, «dbIndex», must be the name of a Variable (normally an index) in your Analytica model that is defined with a DbQuery() statement. If the second argument, «column», is a text value, it identifies the name of a column label in the result table, in which case DbTable() returns a 1-D array (indexed by dbIndex) with the data for that column.

If the second argument is a list of text values (the «columnList» form), then DbTable() returns a 2-D table with records indexed by dbIndex, and columns implicitly indexed (i.e., self-indexed/null-indexed).

If the second argument is the name of an Analytica Variable (usually an index) whose value evaluates to a list of text values, those text values become the column headings for a 2-D table with columns indexed by «columnIndex», and rows indexed by dbIndex. With this last form, «columnIndex» may be defined as DbLabels(dbIndex).

Library

Database Functions

See Also

• DbTableNames
• DbQuery
• DbLabels
• Database functions
• Database access
• DB conversion lib.ana
• DB Conversion Library