You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field.


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 'User defined list'.
6. Click Save.
7. Define the desired values for the configurable lookup.
  Expand the User defined list configurable lookup values section.
8. Click New.
9. In the Value field, type a value.
10. In the Description field, type a value.
11. Sub-task: Change sequence of configurable lookup values.
  11.1 You can change the sequence of the user-defined configurable lookup values. The sequence you define here is the sequence in which the values are shown when you open the configurable lookup for a field.
  In the User defined list of configurable lookup values section, in the list, find and select the desired record.
  11.2 Click Up.
  11.3 In the User defined list of configurable lookup values section, in the list, find and select the desired record.
  11.4 Click Down.
12. Close the page.
Related to Notes

Set up configurable lookup

 

Provide feedback