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, 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
+
[[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 =
+
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

See Also

Comments


You are not allowed to post comments.