- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 01:15 AM - edited 07-16-2025 01:29 AM
while sending data to HR profile using transform map
I already mapped one source field with a target user field in servicenow which is a coalesce field.
Now another field I need to map with a field in HR profile which is coming from user table.
I am getting this error.
I already mapped it with one user field with the reference value fairsall id
I need to map it with employee category which is also coming from user table also. This is the requirement.
What to do now?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 01:18 AM
Hello @Apaul ,
You can map a value to the field one at a time.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 03:00 AM
Hello @Apaul ,
I am confused now
.
Is your target field on User table or HR Profile table? If it is on HR Profile table, are you getting this field on HR Profile table by dot walking from user table ?
And one more -
If you are updating the value on HR Profile table which is coming from the user table then it will update it on the User table.
_______________________________
I am doing the HR one, if i do this, is it going to affect the user table data too? (Answer of your question) -> Yes
Thank you.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 02:18 AM
Oh I did the same before but didn't work, let me debug
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 02:21 AM
tell me one thing, if the target is in user table which is coming to the hr profile using dot walking
, should i write target.u_employee_category or target.user.u_employee_category
Importing the data into sn_hr_core_profile
u_employee_category field is in sys_user table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 02:28 AM
Glide the user table and then use target.u_employee_category = source.<field_name>
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 02:29 AM
@Apaul - Directly it will not update. I think you need to update it on the user table
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2025 02:39 AM
but a vital question
if i glide user table, is it gonna affect the existing transform which is there in the user table?
two transform, one to user table, another to HR.
I am doing the HR one, if i do this, is it going to affect the user table data too?