Hi @Michael51
You can load the excel into staging table and transform using transform map.
In your transform map use below logic in onComplete script.
Try this code :
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
var impSet = import_set.sys_id ;
var cartId = GlideGuid.generate(null);
var cart = new Cart(cartId);
var gr = new GlideRecord('u_ritmload'); // give your staging table here
gr.addQuery('sys_import_set='+impSet);
gr.query();
while (gr.next()) {
var item = cart.addItem('1391a4db070630100b36f6fd7c1ed0c2', 1); //give the catalog item sysid
cart.setVariable(item, 'mutliline', gr.u_col1 ); //add all your variable details here
cart.setVariable(item, 'mutliline', gr.u_col2 ); //add all your variable details here
}
var req_id = cart.placeOrder();
gs.info("number"+req_id.number);
})(source, map, log, target);
I've tried this and it's working.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP
