question Easy Import: removing values in HAM forum

Easy Import: removing values

smithro — Fri, 26 Jul 2024 16:43:20 GMT

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?

Re: Easy Import: removing values

Tony Chatfield1 — Sun, 28 Jul 2024 20:48:16 GMT

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.

Re: Easy Import: removing values

Community Alums — Sun, 28 Jul 2024 23:23:11 GMT

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.