Funnel stage: Sorting keys category
Use the Sorting keys category on the Stage tab to specify how the Funnel stage operates.
Key
This property is only required for Sort Funnel operations. Specify the key column that the sort will be carried out on. The first column you specify is the primary key, you can add multiple secondary keys by repeating the key property. You can use the Column Selection dialog box to select several keys at once if required.
Key has the following dependent properties:
- Sort Order
Choose Ascending or Descending. The default is Ascending.
- Case Sensitive
Use this to specify whether each key is case sensitive or not, this is set to True by default, that is, the values "CASE" and "case" would not be judged equivalent.
- Sort as EBCDIC
To sort as in the EBCDIC character set, choose True.
- Nulls position
By default columns containing null values appear first in the funneled data set. To override this default so that columns containing null values appear last in the funneled data set, select Last.