Why can't I import 2 columns of data into a single field.

[James Malgieri]

I have a csv file and am trying to map 2 fields into a single multiline text field - there are 80 records.  Both fields have the same header name.

I thought I would be ale to do this but only the 1st field is imported into the multiline text field. 

Am I able to do this or could something be going wrong?

Jim

[Tony Rossiter · Accepted solution]

@James Malgieri 

The CSV import feature doesn't let you append existing data fields, it's a complete write-over.  I suspect the system sees both columns mapped to the same field and picks the first one. 

I would recommend appending the data into one column in your CSV file first using excel functions and then importing.

[James Malgieri]

Thanks Tony.