Home | Table of Contents | SortWithinGroups | CloverETL 4.6.1
--- | --- | ---
Prev | Transformers | Next

## SortWithinGroups

# Not available in Community Designer

Short Description
Ports
SortWithinGroups Attributes
Details
See also

### Short Description

SortWithinGroups sorts input records within groups of records according to a sort key.

Component | Same input metadata | Sorted inputs | Inputs | Outputs | Java | CTL | Auto-propagated metadata
--- | --- | --- | --- | --- | --- | --- | ---
SortWithinGroups | - |  | 1 | 1-n |  |  |

### Icon

### Ports

Port type | Number | Required | Description | Metadata
--- | --- | --- | --- | ---
Input | 0 |  | For input data records | Any
Output | 0 |  | For sorted data records | Input 0
1-n |  | For sorted data records | Input 0

### SortWithinGroups Attributes

Attribute | Req | Description | Possible values
--- | --- | --- | ---
Basic
Group key | yes | Key defining groups of records. Non-adjacent records with the same key value are considered to be of different groups and each of these different groups is processed separately and independently on the others. See Group Key for more information. |
Sort key | yes | Key according to which the records are sorted within each group of adjacent records. See Sort Key for more information. |
Advanced
Buffer capacity |  | Maximum number of records parsed in memory. If there are more input records than this number, external sorting is performed. | 10485760 (default) | 1-N
Number of tapes |  | Number of temporary files used to perform external sorting. Even number higher than 2. | 8 (default) | 2*(1-N)

### Details

SortWithinGroups receives data records (that are grouped according to group key) through single input port, sorts them according to sort key separately within each group of adjacent records and copies each record to all connected output ports.

#### Sorting Null Values

Remember that SortWithinGroups processes the records in which the same fields of the Sort key attribute have `null` values as if these `nulls` were equal.

### See also

Common Properties of Components
Specific Attribute Types
Common Properties of Transformers
Transformers Comparison

Prev | Up | Next
SimpleGather | Home | Table of Contents | XSLTransformer