Version

    SortWithinGroups

    Short Description
    Ports
    SortWithinGroups Attributes
    Details
    See also

    Short Description

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

    ComponentSame input metadataSorted inputsInputsOutputsJavaCTLAuto-propagated metadata
    SortWithinGroups-11-n

    Ports

    Port typeNumberRequiredDescriptionMetadata
    Input0For input data recordsAny
    Output0For sorted data recordsInput 0
    1-nFor sorted data recordsInput 0

    SortWithinGroups Attributes

    AttributeReqDescriptionPossible values
    Basic
    Group keyyes

    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 keyyes

    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.