Skip to main content Skip to complementary content

Sort

The Sort control is used in tandem with other controls to sort on columns in ascending or descending order.

Sort package

Sort

The Sort control is brought onto the canvas by dragging and dropping it onto the dataflow graph. Connect the outport of the last used package to the control input and select Add Sort Condition; choose the field to be sorted and the sort direction. Connect the outport of the sort package to the input port of the target entity. As in the case of all dataflow packages make sure that the dataflow has been saved; Validate and Execute the dataflow.

sort controller applied to a field

The table below shows sample data for entities with Sort applied. Target entity field 'Client' in target entity ('Client_AB_Union_Sort') has been alphabetically sorted in ascending order (Z-A) after a Union of unsorted source entities (Client_A , Client_B).

Sample data for sort controller

Client_A

unsorted source entity A

Client_B

unsorted source entity B

Client_AB_Union_Sort

sorted target entity AB shows alphabetical sort on name field

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!