Issue with transform map

[Ramu8]

Hi Team,

Can we use two coalesce fields while importing data then data should be loaded either one coalesce field having data

Please advice 

[Prashant Ahire]

The more fields need to be unique when inserting, the higher the chance of creating a new record. It looks for all the fields on a record and if even one is different, it doesn't update, but creates a new one.

https://www.servicenowelite.com/blog/2014/3/30/coalesce-methods

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/conc...

If my answer helped you in any way, please then mark it as helpful.

[Ramu8]

Hi @Prashant Ahire 

Thank you for your information

I updated coalesce as true for two fields and i am using same data which is in service now existing record in the Excel only difference is changing data of some other filed which is not used as coalesce but when I try to import data

The state(sys_import_srate) of staging table going to test state and Able to run transform map but no updates are happening please advice ASAP

[Community Alums]

Hi @Ramu8 ,

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.

[Ramu8]

Hi @Community Alums 

Thank you for your information

I updated coalesce as true for two fields and i am using same data which is in service now existing record in the Excel only difference is changing data of some other filed which is not used as coalesce but when I try to import data

The state(sys_import_srate) of staging table going to test state and Able to run transform map but no updates are happening please advice ASAP