Change order of sort fields

  1. Change the order of the sort fields.
    1. Click any gray bar in front of a field name; the pointer changes to a hand.
    2. Hold down the mouse button and drag the field selection to its new position.
    3. Release the mouse button when the new position is correct.
    4. Click Regenerate to save the change.
  2. Change the sort fields used.
    1. Double-click the name of any sort field. Alternatively, click the field name once to select it and click the drop-down arrow to show a list of available sort fields.
    2. Select a new field from the list.
    3. The new field name will appear indented until you click Apply to save your changes.
  3. Change the sort order for a field.
    1. Double-click the sort direction for any sort field. Alternatively, click the Direction definition once to select it and click the drop-down arrow.
    2. Select an option from the list.
    3. The selection appears indented until you click Apply to save your changes.
  4. Add and configure a sort field.
    1. Click Select, which appears below the list of sort fields. You will see a list of available fields.
    2. Select a field to add to the list.
    3. Configure the sort direction: Ascending or Descending order.
      Note: To learn more about how Flow Designer sorts data, review How Flow Designer sorts data
    4. Click the Sort Type column to select the field's data type. This column is disabled if incoming data is not in string format (see Data Types for more information).
    5. To remove blank space from before and after the value before sorting, check the box in the Trim column.
      Note: The trim option does not modify the value of the field. It only trims the value for sorting. Note that if your incoming data is not in string format, the Trim column is disabled.
    6. Use the Treat Null As column define the placement of null values in the sorted list: largest or smallest. Placement depends on the combination of options selected in the Order and Treat Null As fields:
      Order Treat Null As Placement of null values in sorted list
      Ascending Largest Bottom of list
      Ascending Smallest Top of list
      Descending Largest Top of list
      Descending Smallest Bottom of list
  5. Repeat the above steps to add sort fields.
  6. See Step 1 to rearrange the sort order. change the order to sort first by one field, then sort the resulting order using another field.
  7. Click Apply to save your changes.
  8. To delete a sort field, click the trash can button next to any field to delete it from the list.
  9. Define advanced sort options.
    Important: We suggest that you not change advanced sort performance options without consulting your system administrator. If you change these options, you may negatively affect sort performance.
    1. Click Advanced.
    2. Use the Override sort performance options toggle to change your sort memory and temporary file settings.
    3. Use the In memory record limit field to define the caching and memory to keep before writing to disk.
    4. Define the Maximum number of temporary files to use for sorting.
    5. Use the Compression toggle to change your option for compressing files stored on disk.
    6. Click OK to save your changes.