In Salesforce, we have a robust data management tool, and that is Salesforce data Loader. It handles the mass or bulk data operations very efficiently. One such feature is that the data loader overwrites a field that currently has a value and inserts a blank or null value.
The process of inserting a null value results in deleting the value of a single field using the Data Loader on a batch of records. In this Salesforce tutorial, we will learn to insert null or blank values in Salesforce using a data loader.
The insertion of blank or null values is done with the help of the Data Loader update operation.
Insert Null or Blank Values with the Salesforce Data Loader
To insert null or blank values with the Salesforce Data Loader, make sure you have installed the data loader in your system and have the required access to update the data of the records.
In this example, we will take a few lead records, and there, we will insert the values of the Lead Source field as blank for the selected leads.
For reference, you can export the Lead object data with the fields ID, Lead Name, and the fields in which you have to delete the value or enter them as blank.
In this example, I will enter a blank value in the field Lead Source.
Now delete the fields that you want to keep blank or null and save the CSV file for the update operation.
Now, we have created the CSV file that we will use to update data and insert null values in the object fields.
After this, follow the below steps to insert Null or Blank Values with the Salesforce Data Loader.
1. Open the Data Loader wizard and log in with your credentials.
2. In the Data loader, go to the navigation bar and select Settings -> settings.
3. In the Settings window, activate the checkbox Insert null values, then click on the OK button.
4. Now click on the Update button in the Data Loader.
5. In this step, select the object in which you want to insert the blank values in the fields. In this example, I have selected the Lead object, and after the object, select the CSV file that we have created above to run the update operation.
After this, click on the Next button.