Coalesce setting

[harshi_ramesh]

Hi all

I have set the coalesce in 'ID' field and mapped the same in the transform map. So if I set want to set 'Name' field as well in coalesce, will this create a problem in adding of new records?

For example, if there are records with same name, but different ID itself. Will the record be visible as only one record or each record will appear separately under same name?

Please help me with the solution.

Thanks

HR

[Sid_Takali]

HI @harshi_ramesh  It would insert the record because now it checks the unique combination of ID and Name . It does not check just the ID field alone.  Visible as separate record under same name with different ID. 

When coalescing on multiple fields, all coalesce fields must be a match for there to be a collision. Matching some coalesce fields but not all does not produce a match. 

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/concept...

Regards,

Sid

[harshi_ramesh]

Hi @Sid_Takali 

So do you mean to say if the name is same, but ID is different this will allow for creation of new record or will update the existing record? I'm just confused.

Thanks

HR

[Sid_Takali]

Hi @harshi_ramesh Let's understand this with example

suppose there is a record already present in system with ID - 123AB and Name - John

now you make ID and Name both field as Coalesce and run transform again

with ID - 123BC  and Name - John.

This will create a New Record as Coalesce checks the unique combination of ID and Name. 

I hope you get it. Cheers

Regards,

Sid

[harshi_ramesh]

Hi @Sid_Takali 

Got it well. Thanks for clearing the doubt.

But have one more question. What if now coalesce is just in name field, we have a record 02ac in the target table. Now a new record comes from the staging table with 02AC. So the record 02ac will get updated right?

Thanks

HR