Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

how to update the User Name by using User ID through Data load?

sowmyab
Giga Contributor

‎03-14-2017 10:13 AM

how to update the User Name by using User ID through Data load?

Hi ,

    Please suggest me on the below request:

I'm loading data through Data Source(Import set table)

I'm passing value as User ID to   User field -, but in form i want to show the User Name not the user Id for this need to write any transform script on the transform map or any other way ?

Example User ID - 103452   (" sys_user" table )

User - Sai (user field need to update with "Sai" not with "103452 "(user id).

i uploaded the file, its updating with User ID only not with Name.

Please let me know if any one knows the solution.

0 Helpfuls
  • 3,710 Views
5 REPLIES 5

sowmyab
Giga Contributor
In response to Alikutty A

‎03-15-2017 01:16 AM

No, i mapped correctly.Thank you.


I found the solution.


I change the type as String from Reference   in "Assigned To" field in Source Table, now its working he he.


Before "Assigned To"   filed type is Reference (sys_user), Now i changed to String - This is the solution.


Directly User ID will convert to User 'Name in Target table.


0 Helpfuls