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]

What is the coalasce here in the transform map. Where is the import set table?

[gricetdw]

I am not coalescing on any field at this point. The import set looks correct and has my data from the file.

[Abhinay Erra]

I am confused here, you are pointing company field which is on target table to import table again. Can you let me know your use case here

[gricetdw]

Abhinay, I'm not sure what you mean that I am pointing company field to import table again? The target table is "ar_task". This should be a pretty straight forward use case. I am simply trying to import into a table that has a reference field.

Target table = AR_TASK

AR_task has a field called "company" that is a reference a table called "u_ar_company". I know I need to load the company field in the AR_Task table with the sys_id of the corresponding record in u_ar_company.   I just cannot figure out how to get the transform map to do that.

[gricetdw]

I just go it to work. It was a lot more simple than I thought. I just needed the correct field name on the reference field for the match. All seems to be working now.