Is it possible load data without field map

[nagaklv]

Hello Community,

Is there any possibility without field map to update traget table records with import sets.If so can anyone help me with sample script and it will not create new records it should check source sys I'd with traget sys I'd if identity it should update the target records.

Thanks,

[Ahmmed Ali]

Is u_element_id field has sys_id or number value?

try below script to cover both scenarios:

var gr = new GlideRecord('change_request');
gr.addQuery("sys_id", source.getValue("u_element_id")).addOrCondition("number", source.getValue("u_element_id"));
gr.query();
if (gr.next()) {
	//update fields here as per your requirement
	gr.description= source.u_value;
	gr.update();
} else {
	ignore = true;
}

Create onBefore script in transform map and add below script:

if(action =="insert"){
    ignore = true;
}

[nagaklv]

Tried with above suggested script but it's not coping the data in the target table

[Ahmmed Ali]

Can you add below script and let me know what you are getting in logs.

gs.log("initiated the tansform", "updateChange");
gs.log("Element: " + source.getValue("u_element_id") , "updateChange");
var gr = new GlideRecord('change_request');
gr.addQuery("sys_id", source.getValue("u_element_id"));
gr.query();
if (gr.next()) {
gs.log("record found: " + gr.number, "updateChange");
gs.log("Value: " + source.u_value , "updateChange");
	//update fields here as per your requirement
	gr.description= source.u_value;
	gr.update();
} else {
	ignore = true;
}

[nagaklv]

Now it's printing the logs and copying the data into field but the strange thing is we have three values(entries) with same sys_id's but it's copying only one value in the description field is there any way to copy all the three entries values line by line?

[Ahmmed Ali]

just replace 

gr.description= source.u_value;

with 

gr.description= gr.description + "\n" + source.u_value;