problem with split by value

[Former Member]

Hi Experts,

i have a problem with split by value function my sr structure is

Sr structure

orders

detail

item no

item name

cost

quantity

target should be

orders

detail

item no

item name

cost

quantity

detail

item no

item name

cost

quantity

i should get new node using split by value for ever new item no followed by other fields

Thanx

Sampath

[Former Member]

Hi,

You can achieve this using Explicit context selection this is along with the SplitByvalue.

Do like this:

Click on the node of the Source Structure where you want to insert the Context change, right click> select Context Change> select the node level you want to insert the context change.

Test the mapping now.

Best Regards

Praveen

Take help from this Mapping presentations:

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e6d433a-0b01-0010-1093-ff0dc0b38810]

Regards

Praveen

Edited by: Praveen Kurni on Aug 21, 2008 1:15 PM

[Former Member]

hi

for split by value, map target detail node with item no. using SplitByValue with each value option.

Regards

Raj

[Former Member]

As you want your node details to be repeated no of times item comes

itemno(set context to root node) --->split by value(each value) --> Details

So details will repeat for every item no

looking at the context, display queue you can do rest of the mapping

[Former Member]

Hi Mugdha,

it is working but the out what i am getting is

item no

item no

item name

item name

cost

cost

quantity

quantity

for the input

orders

details

item no

item name

cost

quantity

item no

item name

cost

quantity

details

orders

regards

Sampath

[Former Member]

Check occurrence of itemno, name... in target structure... it should be 1.. and occurrence of Details should be unbounded..

so new itemno will be put in the next occurrence of Details