Overview
When Kettle is used locally it is possible to manipulate multiple rows allowing sorting on values in each row. Previously Alterian CX would not support his functionality. Alterian CX worked on a Row by Row based that did not allow comparision between rows and therefore sorting. This limitation has been removed and with the Alterian Sort Rows step you can gather togather rows and sort accross them.
Locally any field can be used as the Grouping field. When the step is used within Alterian CX we only support our standard Sequence Number. Please always use this as the Grouping field if you intend to use this step within lterian CX.
Within the plugin:
The following settings can be configured:
Setting | Description |
|---|---|
Step Name | Allows you to name the step to differenicate it from others with the same default name. |
Grouping Field | This is the field that will be used to “Group” the rows before comparision and sorting. If the Step is used within alteiran CX this MUST be the Sequence Number. |
Output field name | Name of the Output field |
Fieldname | Name of the field on the stream to sort on. |
Ascending | Specify Y to sort in ascending order. Specify N to sort in descending order |
Case Sensitive Compare | Specify Y to sort by case usage. Specify N to ignore case. |
Sort based on current locale? | Specify Y to sort based on the system's current locale. Specify N to sort based on a standard UTF-8. |