property int NumColumnIndexes

Description

This property is used to access information about the table pivot that would be used by desktop Analytica (DTA) to view this table. Information about the pivot is stored in several attributes, such as ReformDef and ReformVal, but is computed based on this information and several additional heuristics that take several other factors into account, including the lengths of the indexes, their textual names, etc.

This property reveals the number of column indexes. Currently this can be either 0, 1, or 2. In an edit table, it can be only 0 or 1 (i.e., either there is a column index or there isn't). In a result table that uses a comparison index, there will be 2 column indexes. When there is a comparison index, but the column pivoter is set to nothing, this property returns 2, but NthColumnIndex(1) is Nothing (in VB) or null (in C++, C#).

Note: in future releases, it is possible that the pivot may permit more than two column indexes.

Data type

int

Access

read

Usage

if tab.NumColumnIndexes>0 then ...

History

This property was introduced in ADE 5.0. It is unavailable in releases prior to that.

CATable::NumColumnIndexes

Contents