Skip to Content
0
Jan 18, 2011 at 09:45 PM

Import into Lookup Hierarchy Multi-Value Field

34 Views

My source data contains two fields (Product ID, Product Notes). I need to map the Product Notes into a Hierarchy Lookup Field on main products table. THe hierarchy table for product notes contains two text fields and both are display fields. My source data for product notes contains a comma delimited list of values that only apply to one of the display fields of the Hiearchy table.

Example:

product1 | 1,5,10

product2 | 1,3

product3 | 1,6,13

How do I map and assign the multiple product notes to each product?