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.

[Karan14]

Hey,

I am facing the same issue. It would be great if you could tell me what you changed u_customer_number to in your case.

Thanks in advance,

Karan