問題文
A field currently stores a region as free text, and reports show many spellings of the same region. Going forward the value must be chosen from a fixed set, and the existing values must be cleaned. What is the appropriate approach?
選択肢
- Add a duplicate rule that compares the region field.
- Change the field to a picklist with the agreed values, then correct the existing records with a data load.
- Leave the field as text and add a validation rule that lists the allowed spellings, so that the existing records stay untouched while new entries are limited to the agreed set of values.
- Create a bucket column in each report that groups the spellings together, leaving the stored region values as they are.