Insert null value in a field with Data Import Wizard #inSalesforce

on

Data Import Wizard ignores empty cells in a CSV file.

Instead of clearing the value of the field, it treats the empty field as though you do not want to make any changes to that field.

To set a field value to null or erase the current value, fill out the column corresponding to the record and field to be updated with #N/A. The exceptions are a checkbox where you have to use 0 for unchecked values.

Import Wizard cannot null a lookup (Use an API tool like the Data Loader).


Example:

ContactID           DoNotCall       Title

005xxxxxxxxx0Ta         0           #N/A

005xxxxxxxxx1ZT 1           Salesforce Administrator

 

Visual: https://www.youtube.com/watch?v=ZqMVZucWdz4


Reference: 

https://help.salesforce.com/s/articleView?id=000314136&type=1

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/datafiles_csv_valid_record_rows.htm

https://help.salesforce.com/s/articleView?id=000327368&type=1

Comments

Post a Comment