To merge two sorted inputs complete the following steps:
Procedure
- In the Activities tab, open the Data
Quality directory to find the Merge activity.
- Add the activity to an orchestration. The Checklist and Summary for
the activity are displayed below the orchestration.
- From the Checklist, select Configure and
specify the following information:
- The variable name of the left
variable that contains the recurring element, which the activity loops
through.
- The element name of the recurring
element in the left 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 above.
- The variable name of the right
variable that contains the recurring element, which the activity loops
through.
- The element name of the recurring
element in the right 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 above.
- From the Checklist, select Merge
Properties and specify the following information:
- Select a merge
type for the list.
- In the Left Sort Key section,
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 the ascending or descending to
sort 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.
- Repeat steps (b - e) for the Right Sort Keys.
- Optional: Select
the Ignore Case option. If you select this
option, the case of the data is ignored during the merge process.
- Optional: Select
the Ignore Leading and Trailing Whitespace option.
By default, the merge process reads any white space around data. If
you select this option, the activity ignores white spaces that can
affect the merge results.
- In the Checklist, select Map
Outputs. The following elements are displayed in the From
Activity pane: mergedXml 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.