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]

Ok,

So I think you might be potentially confusing how a field map works. 

What you've got there is saying, "set the value of the User field on the sn_hr_core_profile table by using the u_emp_id field on the sys_user table".

Do you have a u_emp_id on the sys_user table?

[Johny1]

Yeah we have "u_emp_id" on sys_user table which is custom field.

[Kieran Anson]

Add a transform script that runs onBefore like below:

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	if(gs.nil(source.field_name_here))
		ignore = true;
	
})(source, map, log, target);

Replace "field_name_here" with the field name of the field you're mapping to the u_emp_id from the transform table.

[Anil Lande]

Hi,

1. Make sure you have unique value in column u_emp_id in your incoming data records.

2. If you have records with empty emp_id then you can use below checkbox to insert that records.

3. If you don't want to use emp_id as unique identifier then make colease = false in field mapping.

Thanks,

Anil Lande

[Johny1]

Hi @Anil Lan This is a coalesce field which needs an update via transform maps.

When not data found this will be ignored. It is ignoring but the error messages appears which i need to avoid.