transform map

[Gaurav69]

Hii. I have a xml file having two records. as mentioned in the picture attached. In the out of the box user table sys_user, I have these users with user id and emails as in the 2nd attached image. I want to update the emails of my these two users as in my xml file using transform map. How to configure it?

Thanks in advance

[Tony Chatfield1]

Hi, this is the same basic question that you asked here 
transform map - ServiceNow Community

and then did not respond with clear details when they were requested.

Multiple threads that are not updated\responded to, are less likely to see a clear resolution.

Perhaps you could update 1 thread with clear details of your import process and the issue(s) you are facing.
Are you importing the xml file directly to the temp data table, or are you 'loading' the file via the data import process?

Import sets (servicenow.com)
Does your xml file meet the requirements IE does it have a consistent XPath for each data row.

Import sets key concepts (servicenow.com)

[1234av]

You can update the email of users via load data and transform map.

[Community Alums]

Hi @Gaurav69 ,

Firstly You need to create data source and in that data source you need to create one staging table in that staging table your excel file data got stored and than you have to create one transform map in that transform map you need to make the mappings of email field of excel file to the email field of sys_user table. 

Please check above image of data source for your reference.

Transform map image for reference

In related list of transform map you find field mapping please map user.id with user_id of user table and make it Coalesce and than map email field of staging table to email field of user table. So in that case it will update the email field only of that particular record.

Finally you need to run the data source once so that all your excel file data got stored in the staging table than you have to run the transform map so your mapping is all done.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak