How to concatenate 2 source fields into 1 target field on a transform map

[Charles Hong]

Hello - i have a transform map importing in data from an excel sheet and i want to take 2 fields from the spreadsheet and concatenate them into one field onto the importing table.I have tried multiple scripts but can't seem to work. Could someone please give me some input on my script below? 

[Harsh Vardhan · Accepted solution]

you can add another space between two string.

here we go. 

var op = abc+' '+abc1;

[Charles Hong]

thanks. 

[David36]

answer = (function transformEntry(source) {

// Add your code here

var abc =source.fieldA;

var abc1 = source.fieldB

var op = abc+' '+abc1;
return abc; // return the value to be put into the target field

})(source);

This option did not work for me as returning abc only returns the source.fieldA so I changed it to the following, and it worked:

var op = abc+' '+abc1;
return op; // return the value to be put into the target field