How to clear Choice field via Easy Import Update

[vcicchirillo]

Hi all,

With the function "Easy Import" (Import External Data into *name of table*), I would like to clear choice fields of existing data, but through various attempts the field is not cleared but the choice entered previously remains. 
To avoid misunderstandings, I'm using the following function and downloading the template indicated in step 1:

In the excel template, I select the choice "--None--" instead of the previous data:

But as soon as I upload the file to ServiceNow, the field does not update.

Could you by any chance help me?

Thank you.
Vito

[James Chun · Accepted solution]

Hi @vcicchirillo,

I don't think this is feasible with the Easy Import - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0745278

You may need to create an Import Set & Transform Map instead.

Cheers

[vcicchirillo]

Thank you James.

Although you de-check "Copy empty field" in the Transform Map automatically created for Easy Import, this selection is automatically reset during a new upload. Therefore, it can only be done via a dedicated transform map.

[Mark Manders]

How did you 'fill' the field? If you do an export, it will show you the choice options. Did you just delete the field, or did you select 'none', making the field empty.

I just exported some records, set them to 'none' and imported again, and they were updated. Even though 'none' shows empty on the excel, it is a choice in ServiceNow, so you will need to have the field 'filled'. If the field is empty, it doesn't change it.

[vcicchirillo]

Hi Mark, 
Thank you for the reply.

How did you import again the records? 

Previously, I tried to set "--None--" field on the Excel import file and import it via an Easy Import, but the fields did not update.