Sort Data

You can sort the order of your data by using the Order By tab.

To sort your data:

  1. In the Edit Data Flow wizard, select the transform in which you want to sort your data.

    Sorting is supported in the Query, ABAP Query, and XML Map transforms.

  2. Select the Order By tab.
  3. From the Input pane, drag the column containing the data you want you use to sort and drop it into the Order By table.
  4. Specify whether you want to sort in ascending or descending order.
  5. Add additional columns to the Order By tab and arrange them as necessary.

    For example, you might choose to sort your data first by country in ascending order, and then by region in descending order.

    Note
    The data will be sorted in the order that the columns are listed in the Order By tab.