Version

    SortWithinGroups

    SortWithinGroups 64x64

    Short description

    Ports

    SortWithinGroups attributes

    Details

    See also

    Short description

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

    Same input metadata Sorted inputs Inputs Outputs Java CTL Auto-propagated metadata

    -

    1

    1-n

    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

    The 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. For more information, see Group key.

    Sort key

    yes

    A key according to which the records are sorted within each group of adjacent records. For more information, see Sort key.

    Advanced

    Buffer capacity

    The 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

    The 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 a group key) through the single input port, sorts them according to a 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 records in which same fields of the Sort key attribute have null values as if these nulls were equal.