Transform Script update assigned to field in table from source

[Cent]

Hi, just wanted to ask i got a source file with Employee id of a user and want to load and transform it and place it in the assigned to field of a table, specifically alm_hardware table. How can i achieve this? 

from employee id -> transform map -> assign employee id to assigned to field in Hardware table that shows the name of the employee.

Any suggestions and tips?

[debendudas]

Hi @Cent ,

I believe you have source file which contains the Hardware record details.

As you mentioned in the source file you have the Employee ID of the user, then you can use the "Referenced value field name" which is present in the Transform map field mapping.
Please find the below screenshots:

Please make sure you have a Coalesce field in the transform map to avoid duplicate records creation.

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍!