Say im making a transform map that needs to map data from a string field to a lsit field with a dropdown menu. and the source field has data the resembles ["Apples","Banana","Kiwi","Orange. there will be other record from the import table that have differen variations of fruits and some records will have a closing bracket but some wont. Now the dropdown options for the list could be Apples, Banana, Kiwi, Pear, Other. How would you make it so the transform map properly imports the data from the import table to the target table so that the list would show Apples, Banana, Kiwi, Other?
