function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
softectonicsoftectonic 

Mapping multiple fields to one CSV column header

Hi,

 

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

Suggestion

 

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.