+ Start a Discussion

Null Related Lookup field with data loader

Does anyone know if it's possible to null a related lookup field with the data loader? I've tried several times but it's not taking.

Shashikant SharmaShashikant Sharma

If you want to assign null then just leave it blank. Are you inserting or updating.

Ankit AroraAnkit Arora

In which object you are inserting/updating the record? And is this a lookup or a master detail. Also please let me know the exact error you are facing.




Ankit Arora

Blog | Facebook | Blog Page

Rahul SharmaRahul Sharma



I also face the same issue while updating (Deleting Lookup field of) record.

So, I dont think we can delete an Lookup field by giving Null or blank value.

Steve :-/Steve :-/

Do you have "Insert NULL values" enabled on your DataLoader settings?

Rahul SharmaRahul Sharma

Thanks a ton Steve, It really worked!!..