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 (see Object Class)

DataStream Class (see DataStream Class)

SQLSelect Class (see SQLSelect Class)

QueryObject Class (see QueryObject Class)

CrossTable Class (see CrossTable Class)

Inherited By

None

Attributes

None

Methods

None