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

  1. Click the Output node and configure the view that will be output by your intelligent lookup.
  2. 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.

  3. In the Columns section, review the columns that will be output in the view .
  4. [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)Start of the navigation path Next navigation step Set Default ValueEnd of the navigation path, enter a default value in the dialog and click OK.

    The default value is shown on the token under the column name.