Load data from excel in to Glide list field

[gani1]

Hi All,

I have comma seperated users field in my excel and I'm tryingto load in to glidelist field on my table using transform map. Below is my script which I have placed under Field map in transform map but it isn't working. What am I missing?

Thanks

[Chuck Tomasi]

Hi Ganesh,

I generally don't use source scripts on each field. Have you tried something similar in the main transform script to set target.u_vendor_manager using this function?

var final = source.u_vendor_manager.toString().split(',');

var answer = [];

for (var i = 0 ; i < final.length; i++) {

        var usr = new GlideRecord('sys_user');

        if (use.get('name', final[i])) {

                  answer.push(usr.getValue('sys_id'));

        }

}

target.u_vendor_manager = answer.join(',');

[gani1]

Got it. Please ignore

[salvatore]

how u resolved it? please i have  a similar problem