You can set up a configurable lookup of type 'Dynamic query' to define the possible options in a field with a dynamic query.


Standard procedure

1. Go to Data quality studio > Setup > Configurable lookups.
2. Click New.
3. In the Configurable lookup ID field, type a value.
4. In the Description field, type a value.
5. In the Configurable lookup type field, select 'Dynamic query'.
6. Click Save.
7. Define the query and related settings for the configurable lookup.
  Expand the Dynamic query configurable lookup values section.
8. In the Dynamic query field, enter or select a value.
9. Define the field in the dynamic query which value is used to define the configurable lookup.
  In the Dynamic query lookup value field field, enter or select a value.
 

Note:
- Define a field that exists in the dynamic query.
- The field can be another field than the field to which you apply a validation rule that uses the configurable lookup.
- Make sure, the data type of the field is compatible with the data type of the field to which you apply a validation rule that uses the configurable lookup.

10. In the Dynamic query lookup value description field field, enter or select a value.
Related to Notes

Set up configurable lookup

 

Provide feedback