We’ve talked about how you can configure Apex Data Loader to recognize null value when inserting/updating a data field in our previous blog and similar setup is available in Jitterbit Data Loader as well. In Jitterbit Data Loader, the “Insert null values” option is available in the “Advanced Options” of each operation profile instead. Once the checkbox is checked, the operation then recognizes the incoming null values rather than ignoring these fields.
Because this option is available in the operation profile level, you can configure a different set of profiles and decide whether to have the “Insert null values” option checked. This saves up the hassle to enable/disable the option before you execute the next operation profile.