- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2015 02:51 PM
In a transform fields, I have coalesce on 2 fields . So while transforming, is my imported record for validated against all fields marked as coalesce?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2015 02:52 PM
When you coalesce on two fields both fields need to be validated before a change is made.
If multiple fields are set to coalesce, all coalesce values must match an existing record. If two fields are set for coalescing and a matching value is found for one of the coalescing fields but not on the other, a new record is inserted.
For more information please review:
http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2015 02:52 PM
When you coalesce on two fields both fields need to be validated before a change is made.
If multiple fields are set to coalesce, all coalesce values must match an existing record. If two fields are set for coalescing and a matching value is found for one of the coalescing fields but not on the other, a new record is inserted.
For more information please review:
http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0