Mapping fields in transform map

[Apaul]

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? 

[Shraddha Kadam · Accepted solution]

Hello @Apaul ,

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

[Shraddha Kadam]

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

[Shraddha Kadam · Accepted solution]

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

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

[Apaul]

This one helped me alot to understand that this implementation should not be happened. Thanks a lot.

[Shraddha Kadam]

Welcome !

[J Siva]

Hi @Apaul 
You cannot have multiple mappings for a single target field. Also, based on your screenshot, it looks like you're trying to map the category value to the user field, which is incorrect. Please select the appropriate target field.
Regards,
Siva