Configure the View Output by an Intelligent Lookup
Your intelligent lookup outputs a view that can be used as a source for other views. The view is available for use as soon as the intelligent lookup is run.
Context
You can use the output of your intelligent lookup as a source for a view or data flow, where it will be listed in the Source Browser on the Repository tab in the Intelligent Lookups category.
Procedure
Click the Output node and configure the view that will be output by your intelligent lookup.
In the General section, enter the following properties:
Property
Description
Business Name
Enter a descriptive name to help users identify the object. This name can be changed at any time.
Technical Name
Displays the name used in scripts and code, synchronized by default with the Business Name.
To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
Semantic Usage
[read-only] The semantic usage of the view produced by an intelligent lookup is always set to Relational Dataset.
Include Review Records
Include all records that remain in the Review category in the output.
Default: On
Include Unmatched Records
Include all records that remain in the Multiple and Unmatched categories after all rules are applied in the output. Input records in these categories have default values assigned in their return columns.
Default: Off
Include "Unmatched Record" Column
Adds an Unmatched Record column to the intelligent lookup output.
This column contains the value Yes if the record remains in either the Multiple or Unmatched category after all rules are applied.
In the Columns section, review the columns that will be output in the view .
[optional] To set a default value for a return column (to be used when the Include Unmatched Records option is enabled), hover over the return column, click (Menu)Set Default Value, enter a default value in the dialog and click OK.
The default value is shown on the token under the column name.