Toggle Side Panel
Close search

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

Tagged: , , , , ,

  • shradha jain

    Member
    July 25, 2018 at 1:01 PM

    Hello Prachi,

    Perform the following steps to insert null values in dataloader:

    1. Login the DataLoader.
    2. Go to Settings.
    3. Insert Null Values.
    4. Click Ok.

    and then you can insert the null values in the Salesforce Records

  • [adinserter block='9']

  • Avnish Yadav

    Member
    September 10, 2018 at 7:26 AM

    Hello,

    Login the DataLoader->Settings->Insert Null Values->Ok

    then you can insert the null values in the Salesforce Records

    Thanks.

     

  • Parul

    Member
    September 10, 2018 at 12:38 PM

    To set a field value to null, fill out the column corresponding the record and field to be updated with #N/A. The only exception is checkbox where you have to use 0 for unchecked values.’

    Login the DataLoader->Settings->Insert Null Values->Ok and then insert the null values.

     

    Thanks.

  • shariq

    Member
    September 15, 2018 at 10:38 AM

    Hi,

    Here is the tip –

    Uncheck the “Insert Null Values” box in Settings! In most cases you’ll want that unchecked so you don’t inadvertently wipe out good data the next time you run the Data Loader.

    Hope this help.

Log In to reply.