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
In the Activities tab, open the Data
Quality directory to find the Sort activity.
Add the activity to an orchestration. The Checklist and Summary for
the activity show below the orchestration.
From the Checklist, select Configure and
specify the following information:
The variable name of the variable that contains the
recurring element, which the activity loops through.
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.
From the Checklist, select Sort
Properties and specify the following information:
Optional: Select Remove
Duplicates, so that the activity sends duplicates to the remainderXml element.
Click Add. A new row is displayed
in the Sort Keys table.
In the XPath column, specify
the recurring element.
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.
Select the Datatype field and
from the list, choose either the text or number data
type. The default data type is text.
Optional: Select
the Ignore Case option. If you select this
option, the case of the data is ignored during the sort process.
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.
In the Checklist, select Map
Outputs. The following elements are displayed in the From
Activity pane: sortedXml and remainderXml.
Click Select Outputs... and select
the output variables for the map. For instructions about creating
variables, see Creating variables.
As appropriate, map the output parameters to the variables.
For mapping instructions, see Creating a map.