two fields are made coalesce, if both match, record is updated. if any one is not matched then record should not insert/created

[nitin51]

two fields are made coalesce, if both match, record is updated. if any one is not matched then record should not insert/created

EX:

in CMDB_CI table, name field and class are made coalesce, 

if any one field is not matched/same, new record will be inserted(normal function), but i dont want that record to be inserted/ created.

only if both fields matched, then record should be updated.

[Aman Kumar S]

What are using to import the records, import sets?

[Aman Kumar S · Accepted solution]

If yes, use this in transform map script:

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

[dmathur09]

Hi Nitin,

This is an OOB behavior, what issue are you facing with?

Regards,

Deepankar Mathur 

[nitin51]

Hi Deepankar,

Thanks for your reply,

OOT behavior is "two fields are made coalesce, if both match, record is updated. if any one is not matched then record will be created".

What I want is "if any one field is not matched then record should not insert/created"