How do you change a text field to be a lookup field?
- Create a new data type for the lookup field
- Add the new data type as a data column to the data type you are replacing the text field on
- Create a new data mapping that maps the single line text values to the lookup field (this will populate the lookup data type)
- Delete the text field from the data type