+ 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) 
skodisanaskodisana

Hi,

 

This has be setup from dataloader settings.

 

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

 

Thanks,

Srikanth. K