0 / 0
Funnel stage: Sorting keys category

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.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more