COPY EMPTY FIELDS chek box in import sets?

--oooo-- · ‎03-22-2023

Hello Experts,

I want to know the use of copy empty filed on transform map form .can anyone please guide what is use of this filed with a simple example.

Thank You

priyasunku · ‎03-22-2023

Hi @--oooo--

Select this check box to clear fields with existing values when an incoming field contains an empty value. See Using NULL as a Field Value for information on how to import empty values..

Also refer below links

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0623127

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful

Jaspal Singh · ‎03-22-2023

Hi,

If the source being used has empty values it will be overridden to the target table.

So, lets say, you import excel that has empty value & it is mapped to user table. It will update the value on user table to empty.

Ankit7Choudhary · ‎03-22-2023

Hello @--oooo--

Suppose you want to import some records from excel(that contains some user info) for the time being lets assume there are just 2 record in that excel as below:-

Name Email Phoneno.

User1 user@abc.com 123456

User 2 23456

as shown above user2 doesnot have any email value in excel but in Snow sys_user table user2 email is updated as user2@abc.com and you want to replace it from excel , then if you left the "Copy Empty Fields" unchecked then the email for user2 in Snow (the value in the target record) will not change even if you have a blank value in the Excel file.

If you want to change it to blank you have to check the the "Copy Empty Fields" in transform map.

Hope this will solve your issue.

If my response helps you to resolve the issue close the question by ✅Accepting solution and hit 👍thumb icon. From Correct answers others will get benefited in future.

Thanks,
Ankit

jiral · ‎05-12-2023

This will impact all fields if that checkbox is checked. ServiceNow should put that in the field mapping as an option if that rule will only be applied to specific fields.