Any way to set Two coalesce field (For update check ,First || Second )?

[sapna_sagar]

In an import, coalescing on a field (or set of fields) means the field will be used as a unique key. If a match is found using the coalesce field, the existing record will be updated with the information being imported. If a match is not found, then a new record will be inserted into the database.

Is it possible that before insertion , It should check one more field and if match found then updated and not found then finally insert the record??

Means before insertion, It should check two field -

  1st (if not found ) then 2nd (if not found) then only insert.

[Chuck Tomasi]

Coalesce can have multiple fields set to "true" in the field list at the bottom of a transform map. All fields must match for an update to happen. If they don't all match then an insert happens. That's how it works.

http://wiki.servicenow.com/index.php?title=Using_the_Coalesce_Field

[sapna_sagar]

Hi Chuck,

If we"ll set two field in transform map then both should match for update otherwise insertion will happen.

We want that that if we set coalesce field on two field then any one should match for update . if nether 1st matching nor second then only update.

So i want coalesce field in OR Order and not in AND Order.

[Chuck Tomasi]

Sorry, that's not the way coalesce works. You may be able to write something in your transform script, but it could have adverse performance impact on how the import set works - and I'm not sure how you would tell the normal transform/map/coalesce process to abort when your record is manually inserted or updated.

[Chuck Tomasi]

If nobody else on the community has a suggestion, give customer support a call. I'll be curious to hear what they have to say.

HI Service Portal - ServiceNow

Contact Support | ServiceNow