function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Mapping multiple fields to one CSV column header



I mapped multiple Salesforce fields to one CSV column header inside Data Loader .SDL file. The system does not complain and processed the CSV file. However, out of all the Salesforce fields (3 of them)  mapped to a common CSV column header, only the last field in the .SDL file was mapped with the value brought over to Salesforce, the preceeding fields (2) are empty.


How can I mapped a CSV column to multiple Salesforce field  without duplicating the columns in the source CSV file using Data Loader SDL file?


Thanks in advance for your response.


- Softec

Jake GmerekJake Gmerek



Open the CSV in Excel, copy the field so that your CSV has three rows of duplicate data, change the header to header-1, header-1, and header-3 and then map each of your SF fields to one of the rows.