Sorter

Use the Sorter stage to sort records using fields you specify.

You can configure these details for a Sorter stage:

• Order – Displays the sort fields in sort sequence
• Sort Field – Name of the sort field
• Direction – Sort direction: Ascending or Descending
• Sort Type – The type of content in the sort field, such as integer, string, and others
• Trim Blanks – Indicate whether to remove blank space before or after the field content
• Treat Nulls as – Select smallest or largest to direct the placement of null values in the sorted list
• Advanced – Advanced sort options that define overrides for sort performance. We suggest that you not change advanced sort performance options without consulting your system administrator.