Transform Map Script to query the sys_user table and pull a seperate feild

[jacobpeterson]

Hello all,

I'm am trying to create a transform map script that pulls in an Employee number, query's the sys_user table for that Employee Number, and returns the users Full Name.

Below is my current code:

[Dubz · Accepted solution]

Hi Jacob,

If you make the target field a reference field to the user table you can just map directly to that field and set the referenced value field u_employee_id. That should match to the correct record in the user table and return the display value.

[Kalaiarasan Pus]

• Remove return statement.
• Replace while with 'if'
• Replace answer = gr.name;