Transform Map for Reference Fields

[gricetdw]

I have a simple transformation I am trying to load but it will not work. I tried to set the transform field as described in the wiki with no luck.

• Loading data into table called "u_ar_task".
• The u_ar_task has a field called "company" which is a reference to a table called "u_ar_company"
• The ar_company table has a field called "u_customer_number"
• My import file has the customer number associated

• In my transform map I chose the source table as "u_ar_customer"
• Source Field is "Customer Number"
• Target Table is u_ar_task
• Target field is Company
• Referenced field name (I am guessing this is my problem) u_ar_company

See attached. Why won't this work.

[Abhinay Erra · Accepted solution]

This looks fine. Are you sure there are records in the target table with the source customner number?

[gricetdw]

Yes, that is what is baffling me.

Below is the shot of my load file and the associated record in the company table.

[Abhinay Erra]

Is company a reference field to "u_ar_company" ?

[gricetdw]

Thanks for the feedback. Yes it is. Below is the definition.