Easy Import: removing values

[smithro]

Hi Folks,

Trying to do an easy import to update existing records on the alm_hardware table.  When I remove the assigned_to value on the template and make the value blank it does not remove the user's name when I import.  Can you not remove values using easy import?  

[Tony Chatfield1 · Accepted solution]

Hi, looking at the documentation it states

Update a record in the template (servicenow.com)

Original Value	New Value	Result
Blank value	Any non-blank value	Valid update: the update changes the blank value to the new value.
Any non-blank value	Blank value	Invalid update: the update preserves the existing non-blank value.

So I would expect that that this is not possible with OOB Easy Import.

[Community Alums]

You may have to create your own transform map that you'll use to load your template

and write a transform script to wipe the original value if the new value is blank.