Unable to remove reference field value using data import

[Sukhjeet Singh]

Hi,

I am trying to empty reference field values using excel import but it is getting ignored. Kindly help.

Thanks,

Sukhjeet

[Jaspal Singh · Accepted solution]

Hi Sukhjeet,

Hope the reference field is not the primary key. Also, there happens to be 'Copy Empty fields' checkbox available on the Transform map. Hope you have tried checking the same and then getting the data import performed.

[Sukhjeet Singh]

Hi Jaspal,

I wrote script for specific field but wanted solution which would work for all fields. Copy Empty fields was set to false. Thanks for the solution.