Where is the Coalesce option on a Transform map?

[Trish Mac]

Hello,

I'm at a bit of a loss.  There is supposed to be an option to choose if certain fields should be coalesced on a data import, however I don't see the option on the Transform Map or Mapping Assist forms.  I want to coalesce on Category Description/Category and Sub Category Description / Subcategory.  What am I missing please???

Thanks,

Trish

[Tony Chatfield1]

Hi, if you are using Mapping Assist, I believe that you will need to update the field maps at bottom of the Transform Map view once your fields are mapped, example from OOB Computer transform

/nav_to.do?uri=sys_transform_map.do?sys_id=4e3548e2c0a80094002e0c1550d11a26

[Aman Kumar S]

Hey,

You can find coalesce under "Field maps" related list on the Transform map form.

Once you create the field maps, save the form, and navigate to Transform map form.

Ideally you should have the column on list layout, if not, feel free to use GEAR icon on the related list to bring the coalesce column in the list.

How coalesce works?

ServiceNow provides the ability to have an unique key on data imports.  This method of matching is called Coalesce.  In this article, I'll discuss the different ways you can use coalesce and matching possibilities.

Below article explains all sorts of coalesce you can have in servicenow:

https://www.servicenowelite.com/blog/2014/3/30/coalesce-methods#:~:text=Coalesce%20is%20set%20in%20the%20Transform%20Map.,ServiceNow%20will%20update%20that%20record.

[Kartik Sethi · Accepted solution]

Hi @Trish Mac 

Once you are done with the Mapping Assist form, then go to the Related List of your Transform Map.

1. Under Related List Field Maps,
• You can see the Column Coalesce (if it is already configured).
• If you can't find the Coalesce field, then you can personalize the list and bring Coalesce field.
2. After Step1, you can add the desired Field Maps to Coalesce.

Please mark my answer as correct if this solves your issues!

If it helped you in any way then please mark helpful!

Thanks and regards,

Kartik

[Trish Mac]

Hi Kartik, your response and mention of Related List area helped me to locate the Coalesce field.  Frustrating that the Product Documentation wasn't helpful in the slightest for this, only mentioning that Coalesce needs to be checked.  

In the end, the data update failed with unexpected and frustrating results - perhaps because I was updating two fields in the table and I understand there are some complexities to Coalesce that need to be understood.  

I've got a session booked with a SME to go over the process. 

Regardless, your answer was correct for what I was asking and I've marked it as such.

Thanks,

Trish