Fields column settings

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
The Sort rows step includes options to refine your sort based on settings for the individual fields. Click the column titles to sort each column.
Setting Description
Field names Name of the field on the stream.
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.
Collator strength If you selected Y for Sort based on current locale?, specify an integer between 0 and 3 that defines what type of conditional differences govern or override when performing a sort. Exact definitions of each strength vary by locale.
0
Primary. Common example:

a vs b

Case and accents of the letter are not considered.
1
Secondary. Common example:

a vs รค

Accents are considered different, but case is not considered.
2
Tertiary. Common example:

A vs a

Case sensitive compare.
3
Identical. Strings must be identical. Example:

\u0001 vs \u0002

Non-printable control characters are considered different.
Presorted? Select Y if the data in this field is already sorted. Presorting improves sort efficiency. If you select Y, this field must be either the first, or among the first set of fields in the list. Click Presorted? to sort and move all the presorted fields to the top of the table. Select N if the data in this field is not sorted.