Coalesce is not working

VictorS46 · 4 hours ago

Coalesce is reacting differently, When the characters are lowercase it working as expected but when the characters are uppercase it not checking coalesce.

Voona Rohila · 3 hours ago

Hi @VictorS46

Can you please check if ' Coalesce case sensitive' is checked or not in the field map of the transform map? Make sure It's unchecked. check Case-sensitive coalesce field values

Please share screenshot of the issue too.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

GlideFather · 3 hours ago

Hi @VictorS46

there is a checkbox for it:

So you can navigate to this list to see all the fields from transform maps that have this marked true, review if your field is there:

https://yourinstance.service-now.com/sys_transform_entry_list.do?sysparm_query=coalesce_case_sensitive%3Dtrue

EDIT: the URL was incorrect - fixed

———
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */