Fail transform map if the reference field data does not exist

[Manikandan2]

Hi,

I have 2 tables, Service Offering and company. Company table has a reference field referencing Service Offering table. When i do a data import to the company table, if the serivce offering does not exist in the service offering table then it creates an entry in the Service offering table. The requirement is if the Service offering value does not exist in the Service Offering table then the transform map should fail and the data import should not happen to company table.

How do i achieve this?

[Varsha21]

then you should write 

code like

if(serviceoffering is not present condition)

ignore=true;

varsha

[Ankur Bawiskar]

Hi Manikandan,

for this you need to write transform script onBefore

query service offering table with the incoming value;

a) if found then do query on company table;

1) if company found update;

2) if not found insert

b) if not found the service offering use ignore = true and entire row would be ignored

I believe you are running data source on company table here

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Manikandan2]

Hi,

Sorry i am new to scripting. I just need that record to be skipped when the service offering does not exist.

is my below code correct?

if (action == "insert" ) {target. setNewGuid (source. u_sys_id ) ; }
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {


// Add your code here
var ci = new glideRecord('cmdb_ci_vm_instance');
if( ci.next()){
ci.addquery(ci.u_offer_name,source.u_bci_peer_name);

ignore = true;
}

})(source, map, log, target);

[Rahul Kumar17]

var ci = new glideRecord('Service offering table');
ci.query();
var ci_offer = ci.u_offer_name;
while(ci.next()){
if(ci_offer= = source.u_bci_peer_name){
ignore = true;
}
}