You can set up a configurable lookup of type 'Dynamic query' to define the possible options in a field with a dynamic query.
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: |
10. | In the Dynamic query lookup value description field field, enter or select a value. |
Related to | Notes |
---|---|
Set up configurable lookup |
  |