Apex Code Development You need to sign in to do that
Don't have an account?
softectonic 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
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.