Setting Field Reorder Options

There are two ways to reorder fields: custom ordering and automatic sorting.

Custom Ordering

Select Custom Order to enable a table of field names and types where you can view all fields and use arrow buttons to create a custom order.

To reorder fields:

  1. Select a field in the table. Use the Ctrl-click method to select multiple fields.
  2. Use the simple arrow buttons to move the field(s) up or down one row.
  3. Use the line-arrow buttons to move the field(s) to the bottom or top of the list.
  4. Specify the order of fields not included here by moving up or down the divider row, indicated as [other fields].

More information on [other fields]

Other fields. The purpose of the [other fields] divider row is to break the table into two halves.

  • Fields appearing above the divider row will be ordered (as they appear in the table) at the top of all natural orders used to display the fields downstream of this node.
  • Fields appearing below the divider row will be ordered (as they appear in the table) at the bottom of all natural orders used to display the fields downstream of this node.
    Figure 1. Diagram illustrating how “other fields” are incorporated into the new field order
    Diagram illustrating how “other fields” are incorporated into the new field order
  • All other fields not appearing in the field reorder table will appear between these “top” and “bottom” fields as indicated by the placement of the divider row.

Additional custom sorting options include:

  • Sort fields in ascending or descending order by clicking on the arrows above each column header (Type, Name, and Storage). When sorting by column, fields not specified here (indicated by the [other fields] row) are sorted last in their natural order.
  • Click Clear Unused to delete all unused fields from the Field Reorder node. Unused fields are displayed in the table with a red font. This indicates that the field has been deleted in upstream operations.
  • Specify ordering for any new fields (displayed with a lightning icon to indicate a new or unspecified field). When you click OK or Apply, the icon disappears.

Note: If fields are added upstream after a custom order has been applied, the new fields will be appended at the bottom of the custom list.

Automatic Sorting

Select Automatic Sort to specify a parameter for sorting. The dialog box options dynamically change to provide options for automatic sorting.

Sort By. Select one of three ways to sort fields read into the Reorder node. The arrow buttons indicate whether the order will be ascending or descending. Select one to make a change.

  • Name
  • Type
  • Storage

Fields added upstream of the Field Reorder node after auto-sort has been applied will automatically be placed in their proper position based on the sort type selected.