Process Unmatched Results
Unmatched results are input records that are not matched with any lookup record. You can try to manually match them or apply a new rule to them.
Procedure
- Select the rule node and then click (Preview Data) to open the Preview Data panel.
- Click the Unmatched tab.
Two tables are displayed:
-
The left table lists input records for which the rule has found no matches, grouped by pairing column value.
-
The right table lists all of the lookup entity records.
In our example, 5,423 records out of 18,248 have no matches with a score higher than our 80% threshold and so appear on the Unmatched tab.
The first pairing group, Greater London contains 3,104 records:
The following tools are available above the left table:Tools
Description
(Collapse All) / (Expand All)
Collapse or expand all pairing groups.
Rows per Pairing Group
Specify the maximum number of rows to display for each pairing group.
Match
Match all the records in the selected pairing group to the selected lookup record.
(Settings)
Select and reorder table columns.
In the right-hand lookup records table View Settings dialog, you can use the Sort and Filter tabs to sort on and filter by values in multiple columns.
-
- Review each of the pairing groups that the rule has found no matches for.
Select a pairing group in the left table and consult the lookup records in the right table:
-
If you find a lookup record that is a correct match, select it and click Match to move all the records in the pairing group to the Matched tab.
-
If you do not find a suitable lookup record, you can leave the record unmatched.
-
- If appropriate, add a new rule to further process the remaining pairing groups and their match candidates.
Records in the Unmatched category at the end of the flow are not included in the output of your intelligent lookup unless you select the Include Unmatched Records option.