Create a Lookup Set Field

After configuring the lookup-set definition, configure the lookup-set fields. Lookup-set fields are categorized as follows::

  • Selection Fields: These fields represent the source fields available in the Canonical XML used for enrichment.

  • Result Fields: These fields are the destination fields available in the Canonical XML that holds the enriched data.

These configured lookup-set Fields get reflected in the Lookup-set detail as headers. For more information, see Define a Lookup Set Definition Record.

Create a Selection Lookup Set Field

To create a selection lookup-set field, follow these steps:

Navigate to the Types & Values page.

  1. On the page menu, select Lookupset Definitions.

  2. Search or select the preferred lookup type to which you want to add lookup fields.

  3. On the Lookupset Definitions page, click Lookup Fields.

  4. In Selection Fields, click the Action menu Flower. The selection lookup-set page is displayed.

    newlookupsetfields

  5. Enter the following information:

    Item Description

    Name

    Enter the display name of the field in the lookup set.

    Data type

    Select the datatype of the lookup set field from the drop-down. The options are Char, Date and Number.

    Display Format

    Enter the display format mask used to display the value of the field for date and for number columns.

    Order Number

    Enter the order number in which the fields are displayed.

    Field

    Enter the XPath expression that describes the field from the Canonical XML that will be used to compare against the value of the lookup set field.

    Length

    Enter the maximum length of the value that can be entered in the lookup set field.

    Operator

    Select the operator for the drop-down. The options are = , >, <, >=, ⇐, like, priority. It determines the operation that needs to be performed.

  6. Click Save to add the selection field in the look-up definitions. Click Cancel to discard the changes.

Create a Result Lookup-Set Field

To create a result lookup-set field, follow these steps:

  1. Navigate to the Types & Values page.

  2. On the page menu, select Lookupset Definitions.

  3. Search or select the preferred lookup type to which you want to add lookup fields.

  4. On the Lookupset Definitions page, click Lookup Fields.

  5. In Selection Fields, click Flower. The selection Lookup-set page is displayed.

    resultlookupsetfield

  6. Enter the following information:

    Item Description

    Name

    Enter the display name of the field in the lookup set.

    Data type

    Select the datatype of the lookup set field from the drop-down. The options are Char, Date and Number.

    Display Format

    Enter the display format mask used to display the value of the field for date and for number columns.

    Order Number

    Enter order number in which the fields are displayed.

    Field

    Enter the Xpath expression that describes the field from the Canonical XML that will be used to compare against the value of the lookup set field.

    Length

    Enter the maximum length of the value that can be entered in the lookup set field.

    Operator

    Select the operator for the drop-down. The options are = , >, <, >=, ⇐, like, priority. It determines the operation that needs to be performed.

    Field

    Xpath expression that describes the field from the Canonical XML that will be used to compare against the value of the lookup set field.

    Length

    The max length of the value that can be entered in the lookup set field.

  7. Click Save to add the selection field in the look-up definitions. Click Cancel to discard the changes.