Language Reference Guide : System Classes : ColumnCross Class
 
Share this page          
ColumnCross Class
The ColumnCross class creates a single row for all represented values of each row identifier. The arrangement contains a column for each row identifier and for each value represented by the CrossColumn attribute of the CrossTable class.
The following table provides an example of a data set that contains one row identifier (the Key_ID column), values that populate the CrossColumn attribute (the Color column), and aggregate values that represent the data to be returned (the Aggregate column):
Key_ID
Color
Aggregate
abc
blue
1
abc
green
2
abc
red
3
xyz
blue
4
xyz
red
5
xyz
yellow
6
The following table provides an example of a ColumnCross arrangement based on the preceding data set:
Key_ID
Blue
Green
Red
Yellow
abc
1
2
3
null
xyz
4
null
5
6
Null is returned for each column/row intersection that contains no aggregate value.
Inherits From
Object Class
DataStream Class
SQLSelect Class
QueryObject Class
CrossTable Class
Inherited By
None
Attributes
None
Methods
None