How to map string field to reference field using transform map?

[Dinesh Kumar5]

Hi All,

 I am having a requirement to map the string field named 'manufacturer' from import set table to reference field named 'u_manufacturer' on custom table using transform map. And 'u_manufacturer'  having reference to the table named 'u_company'..

Please let me know the solution.

Thanks,

Dinesh kumar G

[asifnoor]

Hello Dinesh,

I assume that manufacturer is the reference field in your target table. In that case, look for the field in the manufacturer table and if its name, then mention your field name in source table as name.

And then in the mapping, under reference field value column mention the name of your column to which the data should be mapped.

Kindly mark the comment as a correct answer and helpful if it helps to solve your problem.

Regards,
Asif
2020 ServiceNow Community MVP

[Ankur Bawiskar]

Hi Dinesh,

that was an example;

Since you already have "u_manufacturer" which refers to "u_company" table

Which field in "u_company" table holds the name of the company; that field you need to set in the Reference value field name

in your field map; select target field as u_manufacturer and I assume u_name is the field which stores manufactured name; so give that

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi Dinesh,

Let me know if that answered your question.

If so, please mark my response as ✅ correct & 👍 helpful so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Regards
Ankur

[Subhojit Das]

Hi Dinesh,

Please go through the ServiceNow document, 

Set Action in Transform Map

If you find the answer useful, please mark as Correct and Helpful.

Regards,

Subhojit Das

[Kajal Goti]

Hi,

You can simply map your sting fields to reference field using choice action

Go to your transform map -> there is related list Fields Map click ->New

you can set source and target field and you can also mentioned there what you want if value of source filed is not available in target field which is reference field

Please mark as Correct/Help,If you find any help worthy