Unable to resolve target record, coalesce values not present: [Script]

[Community Alums]

Hi All, In transform map i am getting below error, 

"

Unable to resolve target record, coalesce values not present: [Script]

" 

Coalesce= True

Use source script checkbox checked

Target field primary mac address

Field script:

answer = (function transformEntry(source) {

    var sourceMAC = source.mac_address.toString();
    var hwPriMAC = target.mac_address.toString();
    var hwSecMAC = target.u_additional_mac_address.toString();

	var cleanedhwPriMAC = hwPriMAC.replace(/[^a-zA-Z0-9]/g, '').toLowerCase().toString();
	var cleanedhwSecMAC = hwSecMAC.replace(/[^a-zA-Z0-9]/g, '').toLowerCase().toString();
    if (sourceMAC == cleanedhwPriMAC) {
        return hwPriMAC; 
    } else if (sourceMAC == cleanedhwSecMAC) {
        return hwSecMAC;
    } else {
		return '';
	}
})(source);

 Please assist to resolved this error, Thanks!

[Tai Vu · Accepted solution]

Hi @Community Alums 

The error message means that the mac_address value does not present in your source table while this field is considered as Coalesce.

For resolution, just ensure the value coalesce value is not empty or null.

Or we can select the Coalesce empty fields check box to match an empty source field value to an empty target field value (but I don't think it's suitable for your case)

KB0547762 - Transform error: Unable to resolve target record, coalesce values not present

Cheers,

Tai Vu