Mapping fields in transform map

Apaul
Tera Contributor

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.

Apaul_0-1752653716583.png

 I already mapped it with one user field with the reference value fairsall id

Apaul_0-1752654572300.png

 


I need to map it with employee category which is also coming from user table also. This is the requirement.


What to do now? 

2 ACCEPTED SOLUTIONS

Shraddha Kadam
Mega Sage

Hello @Apaul ,

 

You can map a value to the field one at a time.

If my response was helpful, please mark it as correct and helpful.
Thank you.

View solution in original post

Hello @Apaul ,

 

I am confused now 

ShraddhaKadam_0-1752660008693.png

 

.

 

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

If my response was helpful, please mark it as correct and helpful.
Thank you.
If my response was helpful, please mark it as correct and helpful.
Thank you.

View solution in original post

23 REPLIES 23

Oh I did the same before but didn't work, let me debug

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

Glide the user table and then use target.u_employee_category = source.<field_name>

If my response was helpful, please mark it as correct and helpful.
Thank you.

@Apaul - Directly it will not update. I think you need to update it on the user table

If my response was helpful, please mark it as correct and helpful.
Thank you.

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?