Unable to resolve target record, coalesce values not present: u_emp_id

[Johny1]

Hello Everyone,
In transform map when the Coalesce value not present on target table record I could see error (Unable to resolve target record, coalesce values not present: u_emp_id) on the transform history import set row errors.
Could you please help me on how to stop this error message. 



Thanks,

Johny

[Anil Lande]

Hi,

This is OOB behavior, if Coalesce field is empty the record is ignored with the error message, this helps to debug if any record is ignored because of empty Coalesce.

Also you can check below KB article for the same issue.

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

Thanks,
Anil Lande