+ Start a Discussion

Multi-valued field

I need to migrate data from my legacy system, where there are multi-valued fields(eg, 2 phone numbers in one field, 3 contact address in one field). What is the best way to map those fields in to Standard Object.

There are only two ways:

1) Separate multi values to different fields. Like Phone1, phone2, Address1,address2, address3 and then create respective custom fields in salesforce and map them while migration.
2) If first option is not feasible, you will have to create phone and address fields with data type text or long text (depend on how long are the different addresses for one contact are) in salesforce.
Thank You. I guess I will go with the first option.