+ Start a Discussion
Static DevStatic Dev 

Update look up field with blank or null.

Hello, i have a quick question. I want to do an update using the data loader where  i need to update a lookup field with a blank value or Null. But as i give a NULL in the cell of my excel sheet an run a update it throws me an error.


So could please tell me how can i update the look up field with a blank value.


Thanks in advance. 

Best Answer chosen by Admin (Salesforce Developers) 



This has be setup from dataloader settings.


go to dataloader--->Settings-->check the checkbox called Insert null Values.



Srikanth. K