Hey Kkim,
I also tried to do the way you were trying to achieve and i was able to get the value in logs but was not able to append in table.
I believe it will not work in this way. In transform map source field you need to do GlideRecord, I tried to send incident short_description and it worked in this way. Please glide the record based upon you coalesce field.
Please find the sample code below:
answer = (function transformEntry(source) {
// Add your code here
var gr = new GlideRecord('incident');
gr.addQuery('incident', source.u_number); // pass the source coalesce field
gr.query();
if(gr.next())
{
var val = gr.short_description + ' ' + source.u_short_description;
return val; // return the value to be put into the target field
}
})(source);
Hope this helps.
