Set up configurable lookup

You can set up a configurable lookup to define the possible options in a field.

You can define the possible options for a configurable lookup in these ways:

User defined list: Set up the desired options manually.
Dynamic query: Apply a dynamic query to define the desired options.
Web service: Use a web service to get the desired options.

To apply a configurable lookup, set up a validation rule of type Configurable lookup. You can use a configurable lookup on several validation rules.

This topic explains how to set up a configurable lookup.

Activities

Name	Responsible	Description
Set up configurable lookup - User defined list	Data quality administrator	You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field.
Set up dynamic queries	Data quality administrator	Use a dynamic query to find one or more records in the database. The found records are the input for further processing. You can use a dynamic query on: An enrichment rule of type Data query. An action rule of type Data query. A condition that is applied to a validation rule, duplicate check rule, or action rule. A configurable lookup of type Dynamic query. You can apply the configurable lookup on a validation rule of type Configurable lookup. To define a query range, you can use a function.
Set up configurable lookup - Dynamic query	Data quality administrator	You can use a dynamic query to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Dynamic query'.
Set up web service configuration	Data quality administrator	You can set up data quality policy rules that use a web service. You can use a web service: Validation rule to validate if a field value matches a value in another internal or external source, using a web service. Enrichment rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule. Action rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule. Before you can set up a web service rule, set up the web service configuration to be used.
Set up configurable lookup - Web service	Data quality administrator	You can use a web service to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Web service'.

Activities

Name	Responsible	Description
Set up configurable lookup - User defined list	Data quality administrator	You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field.
Set up dynamic queries	Data quality administrator	Use a dynamic query to find one or more records in the database. The found records are the input for further processing. You can use a dynamic query on: An enrichment rule of type Data query. An action rule of type Data query. A condition that is applied to a validation rule, duplicate check rule, or action rule. A configurable lookup of type Dynamic query. You can apply the configurable lookup on a validation rule of type Configurable lookup. To define a query range, you can use a function.
Set up configurable lookup - Dynamic query	Data quality administrator	You can use a dynamic query to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Dynamic query'.
Set up web service configuration	Data quality administrator	You can set up data quality policy rules that use a web service. You can use a web service: Validation rule to validate if a field value matches a value in another internal or external source, using a web service. Enrichment rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule. Action rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the enrichment rule. Before you can set up a web service rule, set up the web service configuration to be used.
Set up configurable lookup - Web service	Data quality administrator	You can use a web service to define the possible options of a configurable lookup. To do so, set up a configurable lookup of type 'Web service'.