Copy Empty field giving NULL Value

[Divya Yadav1]

Hi All,

I want to update user record and make first name & last name empty. uploading excel and taking field as blank.

While creating transform map selected Copy empty field as true but getting NULL value instead of empty value in user record.

Any idea why?

Regards,

Divya

[Divya Yadav1]

Hi All, 

I did some testing on my personal developer instance and observed that this is OOB functionality of ServiceNow tool.

But does anyone have any idea where we can find this configuration?

[Mohith Devatte]

Hello @Divya Yadav1 ,

you can try writing an before transform script like below 

if(source.your_transform_map_field_name=="")
{
target.your_target_Table_field_name="";
}

Not sure if this works but you can give a try 

Hope this helps 

Mark my answer correct if this helps you 

Thanks

[Brijmohan]

Hey @Mohith Devatte 

Thanks for the response, but it's not working.

[Mohith Devatte]

@Brijmohan can you try the same  script but this time by unchecking that copy empty values check box and try ?