Sorting Elements for an XML Output File

The Mapper allows you to sort XML output elements in a number of ways:

• Sort XML Output Records Using ORDER BY

• Sort XML Output Nodes in Memory

• Optimize Combine Using ORDER BY

All these options can be set to sort in ascending or descending order. For example, in a typical employee database, you might want to retrieve salary data by department where departments are sorted in ascending order ( A to Z) and salaries within departments are sorted in descending order (highest to lowest.)

1. Create mappings between elements and table columns.

2. In the XML Structure tab, click in the Order By column of  the parent of the element you want to sort.

3. From the drop-down list, choose  Ascending to sort in ascending order and  Descending to sort in descending order.