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

[Kieran Anson]

This indicates that the record doesn't have the required employee id for coalesce to run, and the transform map does not allow for coalescing on a blank coalesce field.

You either need to fix the inbound feed to have an employee number, or ignore any rows where this field is empty.

[Johny1]

@Kieran Anson Inbound feed has a data where it didn't find any match on target table. For this I selected choice action=ignore in the field map record, but still the error is showing.

[Kieran Anson]

Can you attach a screenshot to what you're referring to

[Johny1]

Hi @Kieran Anson