Difference between revisions of "DbTable"
(status) |
|||
Line 4: | Line 4: | ||
''(Requires Analytica Enterprise or Power Player)'' | ''(Requires Analytica Enterprise or Power Player)'' | ||
− | = DbTable( dbIndex, column ) = | + | == DbTable(dbIndex, column) == |
− | = DbTable( dbIndex, columnList ) = | + | == DbTable(dbIndex, columnList) == |
− | = DbTable( dbIndex, columnIndex ) = | + | == DbTable(dbIndex, columnIndex) == |
− | DbTable() is used to get at the data within a result table. The first argument, | + | [[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. |
− | 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 | Database Functions | ||
− | = See Also = | + | == See Also == |
− | |||
* [[DbQuery]] | * [[DbQuery]] | ||
* [[DbLabels]] | * [[DbLabels]] |
Revision as of 21:57, 29 January 2016
(Requires Analytica Enterprise or Power Player)
DbTable(dbIndex, column)
DbTable(dbIndex, columnList)
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
Enable comment auto-refresher