how to ignore if the coalesce field is empty in import sets

[shaik_irfan]

Hi,

On the import sets i have set the email address as coalesce now sometime my source or staging table may have the email address as empty in these scenarios i want to ignore the record to be inserted or updated can anyone please hlep me how to do this ?

what happens when my coalesced source field is empty ?

[Pranav Bhagat · Accepted solution]

Just make sure is Create new record on empty coalesce fields unchecked

If it is unchecked there won't be any records created/updated for empty fields

[Abdul Azeem1]

Hi Pranav,

In my case I have unchecked the  Create new record on empty coalesce fields but still records are getting inserted in target table if coalesce field is empty.

Any suggestions?

Thank you!

[Sukraj Raikhraj]

add an onbefore script on the transform, check if email is empty and add code to ignore on insert.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/import-sets/task/t_AddOnBeforeScriptToTransformMap.html

if(source.u_field1 == '')

  {

  ignore = true;

  }

[Pranesh072]

Uncheck Coalesce empty fields