Activity Forums Salesforce® Discussions How to insert null values into dataloader?

  • Neha

    Member
    September 4, 2018 at 11:25 am

    Hi Anjali,

    Once logged into the Data Loader, the first thing you need to do is go into Setting and click the box “Insert Null Values.” If you do not, your “Update” function will only change a field from one value to a new value, OR, if the field was blank initially, you can populate a blank (or null) field to have a value. Unless that box is checked, you can’t delete an existing field value (erase it) with the Update command.

  • shradha jain

    Member
    September 4, 2018 at 11:27 am

    Hello Anjali,

    Perform the following steps to insert null values into dataloader.

    • Login the DataLoader
    • Go to Settings
    • Insert Null Values
    • Click Ok.

     

  • Parul

    Member
    September 20, 2018 at 6:15 pm

    Hi,

    Please follow steps

    Data Loader  --> settings  -->  Check Insert null Values. It works.

  • shariq

    Member
    September 20, 2018 at 10:50 pm

    Hi,

    Steps sto achieve this -

    Go to the Settings of data loader

    Enable insert null values

    Then try to insert csv with null values in coloumn, this will work for you.

    Hope this helps.

  • Parul

    Member
    September 21, 2018 at 3:34 am

    There is some cases more:

    If you'd like to remove a value from one of your record's fields so it will appear as blank or NULL using the Data Loader, update your Data Loader settings using the steps below:

    Resolution
    Include NULL values in an update
    1.  Open Data Loader.
    2.  Click Settings.
    3.  Select Insert Null Values.

     

    Example
    1.  Run Export Data. Make sure to include IDs and Column Fields that should be changed to NULL.
    2.  Delete data contained in the columns that should be returned as NULL (no values).
    3.  Save the file as a new .CSV with new name (don't overwrite the Data Export from step 1).
    4.  Run Data Loader Update using new file with Blank values.

    Potential Issues

    If the field being updated to NULL is referenced by a workflow or trigger, the update might not be successful. (One workaround you can try is to lower the batch size to 1, then proceed with the update or insert again).
    If the field is Required in your organization, you will not be able to use this method to insert a NULL value.

     

    Thanks

Log In to reply.

Popular Salesforce Blogs