Hi Team,
We have to create multiple RITM's from EXCEL using flow designer. I used Transform map onComplete Script.
Script:
(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);
The above script is working when i am using data load and run the transform map.
if am using the flow designer, the empty records are creating and the same RITM numbers are mapped to import set Target record
My flow Designer is:
help me on the process.
Thanks,
Anil!
