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
  • 4,334 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