Dynamic Coalesce field in the Transform Maps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2021 07:32 AM
Hi Team,
Is there any way to set the "Coalesce" field to true based on the source value in the transform maps? Dynamically setting the "Coalesce" field to true or false based on the value received in the source field. Please provide your support as soon as possible.
Regards
Rahul

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2021 07:36 AM
You can change set Coalesce field dynamically. But, we can build coalesce on more than one fields as well.
Can you give the scenario and example date. We can try building Coalesce accordingly.
Thank you,
Palani
Palani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2021 08:04 AM
Hi,
Currently, we have two coalesce fields in the system. The user id and email id. Based on the email id value we need to dynamically set the coalesce field.
Regards
Rahul

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2021 08:07 AM
So what is your condition on email id field you want to set Coalesce? what are the fields you want to make coalesce dynamically? Please explain with sample data
Palani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2021 08:17 AM
For a particular email id, we don't want to set coalesce field to true. So please provide your inputs to set the coalesce field dynamically by using the Source Script in the field map.