Error in node creation

[Former Member]

Hi

I have a mapping related issue in creating node the way I want. My source structure is like this.

customerOrders

---Customers

-

---

Cust_Id

-

---

Order_Id

---Item

-

---

Cust_Id

-

---

Item_No

My target structure is more or less the same:

customerDetails

---Customers

-

---

Cust_Id

-

---

Order_Id

---Item

-

---

Cust_Id

-

---

Item_No

Item node in source can appear more than twice and for each Item, the node Customers along with the Cust_Id and Order_Id should appear above that.

It should come like this at target:

Customers

Item

Customers

Item

Customers

Item

I am getting like this only:

Customers

Customers

Customers

Item

Item

Item

Item at source has 0..unbounded and Item at target I gave 1..unbounded

I used useOneAsMany with the three inputs, Cust_ID, Item and Item_No and mapped to Cust_ID under Customer. I also mapped Item at soource to Customers at target. I again mapped Item at source to Item at target.

Lastly the Cust_ID under Item node has different values for different Item nodes and I mapped field to field to field.

Regards

[Former Member]

Hi

have you use useoneasmany function for order_id under customer in target?

[former_member184681]

Hi,

I am afraid you could only achieve the required structure by encapsulating Customer and Item in some higher-level node, for instance:

Order

Customers

Item

Order

Customers

Item

Hope this helps,

Greg