+ Start a Discussion
Veekay1Veekay1 

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.
Vinita_SFDCVinita_SFDC
Hello,

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.
Veekay1Veekay1
Thank You. I guess I will go with the first option.