Merging two sorted inputs
About this task
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 beneath 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.
- 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.
- 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.
Parent topic: Merge Activity