Sort Activity

This activity allows you to sort inputs.

Important: Use the Sort activity to sort data before attempting to merge data with the Merge activity.

To sort inputs complete the following steps:

Procedure

  1. In the Activities tab, open the Data Quality directory to find the Sort activity.
  2. Add the activity to an orchestration. The Checklist and Summary for the activity show below the orchestration.
  3. From the Checklist, select Configure and specify the following information:
    1. The variable name of the variable that contains the recurring element, which the activity loops through.
    2. The element name of the recurring element in the variable, which the activity loops through. Click the browse button ( ... ) to open the Select Recurring Element window, where you can view all the elements in the variable you selected.
  4. From the Checklist, select Sort Properties and specify the following information:
    1. Optional: Select Remove Duplicates, so that the activity sends duplicates to the remainderXml element.
    2. Click Add. A new row is displayed in the Sort Keys table.
    3. In the XPath column, specify the recurring element.
    4. Select the Sort Type field and from the list. Choose either ascending or descending sort order for the list. The default sort type is ascending.
    5. Select the Datatype field and from the list, choose either the text or number data type. The default data type is text.
    6. Optional: Select the Ignore Case option. If you select this option, the case of the data is ignored during the sort process.
    7. Optional: Select the Ignore Leading and Trailing Whitespace option. By default, the sort process reads any white space around data. If you select this option, the activity ignores white spaces that can affect the sort results.
  5. In the Checklist, select Map Outputs. The following elements are displayed in the From Activity pane: sortedXml and remainderXml.
    1. Click Select Outputs... and select the output variables for the map. For instructions about creating variables, see Creating variables.
    2. As appropriate, map the output parameters to the variables. For mapping instructions, see Creating a map.