- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 04:33 AM
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?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 08:06 AM
you can add another space between two string.
here we go.
var op = abc+' '+abc1;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 04:37 AM
answer is already a reserved variable so you don't need to declare it .
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 04:54 AM
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 06:39 AM
Last question - when i have "var op = abc+abc1;" there are no spaces in between. How can i do it so there is a space between the 2 values?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2019 06:39 AM
Last question - when i have "var op = abc+abc1;" there are no spaces in between. How can i do it so there is a space between the 2 values?