Transform map returns undefined value in the field

[Miloslav1]

Hello, I was trying to understand what I might did wrong here.

My goal here is to change only value from "###" to "aaa", the rest of the values should remain untouched.

Unfortunately with this easy function script I am able to change the value "###" to "aaa", but the rest of the fields changed its value to "undefined". Can you please let me know what I am missing here? Thanks in advance.

Here is the simple transform map script function:

answer = (function transformEntry(source) {

if (source.u_business_phone == '###' ){ return 'aaa';}

})(source);

Here is the screen from instance before the transform, then the excel sheet with new data and then after the transform is complete.

[Robbie]

@Miloslav1,

Happy to help and glad it solved your issue. 

Thanks,

Robbie

[Saloni Suthar]

Can you please try below logic in your script?

(function runTransformScript(source, map, log, target) {

    if (source.u_business_phone == "###") {
        
        target.u_business_phone = "aaa";
    } else {
      
        target.u_business_phone = source.u_business_phone;
    }
})(source, map, log, target);

If my response helped you, please mark it as correct or helpful.