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

[Jaspal Singh]

Hi Dinesh,

Just make sure the name is passed correctly. As when you do an import for Group & Users for Group Membership table then the staging table is again holding string fields & you pass name not sys_ids so logic remains the same. Make sure names are passed correctly & the way it exists in the table.

[Dinesh Kumar5]

Hi jaspal,

Though i gave a correct name, It is not workinng.

Thanks,

Dinesh

[Ankur Bawiskar]

Hi Dinesh,

so incoming value of manufacturer is string such as IBM and in target table the field is reference to u_company table

which field in u_company table holds the name IBM; I assume if it is u_name then in Reference value field name set the field as u_name

the referenced value field name is the field against which you need to search for

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

[Dinesh Kumar5]

Hello Ankur ,

I am having a doubt that in above u haven't mentioned any referece to 'u_company' table then how it will fetch the data from that particular table. And i am also having the field named 'name' in target table. So will it get fetched correctly.

Thanks, Dinesh