The second Sort for Linking process will sort records in ascending order according to the content of the Window Key 02 attribute, which comprises the e-mail address. You must add this Sort process to your project and then configure its settings to sort the rows correctly.
To set up and run the second Sort for Linking process
-
In the project view, right-click the output of the Relationship Linker process.
-
Click Add process branch. The Create Process window opens.
-
Select Sort for Linking from the Process selection list, select the Configure Now check box and click OK. The Sort Order window opens.
-
Click Insert and specify Window Key 2 as follows:
-
Name: WINDOW_KEY_02
-
Order: Ascending
-
Collating sequence: ASCII
-
-
Click OK.
-
Select WINDOW_KEY_01 and click Delete.
- Click OK in the confirmation message. Only Window Key 02 remains.Figure 1. Sort Order Window
-
Click Finish.
-
Run the process and display the output to verify that the rows are now sorted in ascending order by Window Key 02.