- PowerCenter 10.5
- All Products
California California California Hawaii Hawaii New Mexico New Mexico New Mexico
California,3 Hawaii ,2 New Mexico,3
The name of a state. The source rows are grouped by the state name. The Aggregator transformation returns one row for each state.
The row count for the current State. When the value of the current State column is the same as the Previous_State column, the Integration Service increments State_Count. Otherwise, it resets the State_Count to 1.
The value of the State column in the previous row. When the Integration Service processes a row, it moves the State value to Previous_State.
The number of rows the Aggregator transformation processed for a state. The Integration Service returns State_Counter once for each state.