Ignore field value in transform map if empty

[Khanna Ji]

Hi,

I want to ignore the field update if its coming as empty instead of rejecting the entire row. Is this possible?

For example if state is already existing for a user in user table and if a new value is coming from staging table in which state is blank then that field should not be updated and rest all should get updated.

Is this possible?

[Harshinya1]

Swathi,

https://docs.servicenow.com/bundle/london-platform-administration/page/script/server-scripting/task/t_CreateATransformMap.html

Uncheck the 'Copy Empty Fields' box on transform map 

Copy Empty Fields - 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.

Hope this helps

Please mark helpful/correct if it answered your question

Thanks,

Harshinya

[Khanna Ji]

That is already unchecked.

[Prateek kumar]

In the field map, select the choice action to ignore.

[Khanna Ji]

Choice action is only for reference type fields not for all. Mine is just a string field.