Welcome to Zuora Product Documentation

Explore our rich library of product information

Nulling field values with in Data Loader

The article instructs on how to set field values to null using Data Loader by following a series of steps, including creating a job, selecting the update operation, and modifying a CSV template.

Nulling a field sets its value to blank or removes the existing value. You can null field values using the Update operation in Data Loader.

  1. From the main menu, navigate to Administration > Data Loader.
  2. Click + New and select Update.
  3. Select the appropriate template and select Download CSV Template.
  4. In the downloaded CSV file:
    • Enter True in the IsMarker column, if applicable for the object.
    • Enter a valid Record ID for each row. This is mandatory for updates.
    • Retain only the columns to update.
    • For the fields you want to null, enter Null in the corresponding cells.
    • Delete any unused columns from the template.
    Note:
    • You can update field values and null other fields in the same job.
    • Ensure the field you are nulling is not required in the schema.
    • For custom fields, verify that the default value is blank. Otherwise, Data Loader resets the field to its default value instead of leaving it blank.
  5. Upload the updated CSV file and run the job.